Não Consigo Compilar Package

Pessoal,

Não conheço muito oracle e estou com 1 problema.

Estou tentando alterar um Package que possui algumas procedures.

Ao compilar me gera o seguinte erro:

[Error] PLS-00382 (7: 15): PLS-00382: expression is of wrong type

o que eu fiz foi adicionar 2 campos a mais no retorno do meu select.(PacoteAcordo.ID_AGREEMENT,PacoteAcordo.DT_SYSTEM )

 

SELECT
 PacoteAcordo.ID_PACKAGE_AGREEMENT ,
 Pacote.NM_PACKAGE ,
 PacoteAcordo.NM_FANCY_NAME,
 PacoteAcordo.DT_START_TERM ,
 PacoteAcordo.DT_END_TERM ,
 Segmento.DE_SEGMENT ,
 TipoPacote.DE_PACKAGE_TYPE,
 PacoteAcordo.ID_PACKAGE ,
 NVL(AnexoPacote.ID_PACKAGE_ATTACHMENT, 0) AS ID_PACKAGE_ATTACHMENT ,
 PacoteAcordo.ID_AGREEMENT ,
 PacoteAcordo.DT_SYSTEM

 FROM PRD.TBD_PRD_PACKAGE Pacote
 INNER JOIN AGR.TBD_AGR_PACKAGE_AGREEMENT PacoteAcordo ON Pacote.ID_PACKAGE = PacoteAcordo.ID_PACKAGE
 INNER JOIN PRD.TBD_PRD_PACKAGE_TYPE TipoPacote ON Pacote.ID_PACKAGE_TYPE = TipoPacote.ID_PACKAGE_TYPE
 LEFT JOIN AGR.TBR_AGR_PACKAGE_ATTACHMENT AnexoPacote ON (AnexoPacote.ID_PACKAGE_AGREEMENT = PacoteAcordo.ID_PACKAGE_AGREEMENT)
 LEFT OUTER JOIN PAR.TBA_PAR_SEGMENT_INSURANCE Segmento ON Pacote.ID_SEGMENT_INSURANCE = Segmento.ID_SEGMENT_INSURANCE
 WHERE (PacoteAcordo.ID_AGREEMENT = nvl(P_IDPACKAGEAGREEMENT,PacoteAcordo.ID_PACKAGE_AGREEMENT));

o que pode ser esse erro?