DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 2539: FROM zx_party_tax_profile ptp,

2535: begin
2536: --get ptp id for HQ of the LE
2537: SELECT ptp.party_id
2538: INTO l_hq_party_id
2539: FROM zx_party_tax_profile ptp,
2540: xle_etb_profiles xlep
2541: WHERE ptp.party_id = xlep.party_id
2542: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
2543: AND xlep.legal_entity_id = p_trl_global_variables_rec.legal_entity_id