DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on XLE_ETB_PROFILES

Line 1500: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle

1496: BEGIN
1497: IF p_registration_num IS NOT NULL THEN
1498: SELECT distinct xle.legal_entity_id
1499: INTO l_legal_entity_id
1500: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
1501: where tr.registration_number = p_registration_num
1502: and tr.party_tax_profile_id = ptp.party_tax_profile_id
1503: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1504: and ptp.party_id = xle.party_id;