APPS.ZX_TRN_VALIDATION_PKG dependencies on XLE_FP_ESTABLISHMENT_V

Line 164: from xle_fp_establishment_v est,

160:
161: select regt.registration_number
162: from zx_registrations regt
163: where regt.party_tax_profile_id = (select ptpp.party_tax_profile_id
164: from xle_fp_establishment_v est,
165: xle_fp_establishment_v estp,
166: zx_party_tax_profile ptp,
167: zx_party_tax_profile ptpp
168: where estp.party_id = ptpp.party_id

Line 165: xle_fp_establishment_v estp,

161: select regt.registration_number
162: from zx_registrations regt
163: where regt.party_tax_profile_id = (select ptpp.party_tax_profile_id
164: from xle_fp_establishment_v est,
165: xle_fp_establishment_v estp,
166: zx_party_tax_profile ptp,
167: zx_party_tax_profile ptpp
168: where estp.party_id = ptpp.party_id
169: and estp.legal_entity_id = est.legal_entity_id

Line 300: FROM xle_fp_establishment_v

296: ELSIF p_party_type_code = 'LEGAL_ESTABLISHMENT' THEN
297:
298: SELECT distinct establishment_name
299: INTO l_party_name
300: FROM xle_fp_establishment_v
301: WHERE party_id = l_party_id;
302:
303: x_party_name_token := x_party_name_token ||' '|| l_party_name;
304: x_party_site_name_token := NULL;