DBA Data[Home] [Help]

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