DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on XLE_ETB_PROFILES

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

1540: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1541: IF p_registration_num IS NOT NULL THEN
1542: SELECT distinct xle.legal_entity_id
1543: INTO l_legal_entity_id
1544: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
1545: where tr.registration_number = p_registration_num
1546: and tr.party_tax_profile_id = ptp.party_tax_profile_id
1547: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1548: and ptp.party_id = xle.party_id;