APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_REPORTING_ENTITIES

Line 665: From AP_REPORTING_ENTITIES

661: Cursor C_rep_entity is
662: Select UNIQUE_TAX_REFERENCE_NUM,ACCOUNTS_OFFICE_REFERENCE,
663: TAX_OFFICE_NUMBER,PAYE_REFERENCE,fnd_profile.value('ORG_ID') ORG_ID,
664: CIS_SENDER_ID
665: From AP_REPORTING_ENTITIES
666: Where UNIQUE_TAX_REFERENCE_NUM is not null;
667: Cursor C_prev_return is
668: select nvl(sum(decode(X.nil_return_flag,'Y',1,0)),0) nil_ret_count,
669: nvl(sum(decode(X.nil_return_flag,'N',1,0)),0) non_nil_ret_count