DBA Data[Home] [Help]

APPS.JE_IT_LISTING_PKG dependencies on PER_ALL_PEOPLE_F

Line 805: FROM per_all_people_f

801: zx_taxes_b zxtaxes ,
802: zx_report_codes_assoc zxass ,
803: (SELECT distinct person_id
804: ,national_identifier
805: FROM per_all_people_f
806: WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf
807: WHERE repent.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
808: AND ( ( repent.entity_type_code = 'LEGAL'
809: AND ih.legal_entity_id = gn_legal_entity_id )

Line 1682: FROM per_all_people_f

1678: ap_suppliers pv,
1679: ap_supplier_sites_all pvs,
1680: (SELECT distinct person_id
1681: ,national_identifier
1682: FROM per_all_people_f
1683: WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf
1684: WHERE jit.year_of_declaration = P_YEAR_OF_DECLARATION
1685: AND jit.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
1686: AND jit.APPLICATION_ID = 200

Line 1781: FROM per_all_people_f

1777: ap_suppliers pv,
1778: ap_supplier_sites_all pvs,
1779: (SELECT distinct person_id
1780: ,national_identifier
1781: FROM per_all_people_f
1782: WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf
1783: WHERE jit.year_of_declaration = P_YEAR_OF_DECLARATION
1784: AND jit.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
1785: AND jit.APPLICATION_ID = 200