APPS.JE_IT_XML_LISTING_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 35: zx_party_tax_profile ptp

31: IS
32: CURSOR tax_reg_num_csr(c_registration_number varchar2, c_party_type_code varchar2) IS
33: SELECT ptp.party_id
34: FROM zx_registrations reg,
35: zx_party_tax_profile ptp
36: WHERE ptp.party_tax_profile_id = reg.party_tax_profile_id
37: AND reg.registration_number = c_registration_number
38: AND sysdate >= reg.effective_from
39: AND (sysdate <= reg.effective_to OR reg.effective_to IS NULL)