APPS.ZX_EXTRACT_PKG dependencies on ZX_PARTY_TAX_PROFILE
Line 2998: FROM zx_party_tax_profile ptp,
2994: BEGIN
2995: --get ptp id for HQ of the LE
2996: SELECT ptp.party_id
2997: INTO l_hq_party_id 2998: FROM zx_party_tax_profile ptp, 2999: xle_etb_profiles xlep
3000: WHERE ptp.party_id = xlep.party_id
3001: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
3002: AND xlep.legal_entity_id = p_trl_global_variables_rec.legal_entity_id