APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_REPORTING_ENTITIES

Line 447: From AP_REPORTING_ENTITIES

443: Cursor C_rep_entity is
444: Select UNIQUE_TAX_REFERENCE_NUM,ACCOUNTS_OFFICE_REFERENCE,
445: TAX_OFFICE_NUMBER,PAYE_REFERENCE,fnd_profile.value('ORG_ID') ORG_ID,
446: CIS_SENDER_ID
447: From AP_REPORTING_ENTITIES
448: Where UNIQUE_TAX_REFERENCE_NUM is not null;
449: Cursor C_prev_return is
450: select nvl(sum(decode(X.nil_return_flag,'Y',1,0)),0) nil_ret_count,
451: nvl(sum(decode(X.nil_return_flag,'N',1,0)),0) non_nil_ret_count