APPS.ZX_TRN_VALIDATION_PKG dependencies on XLE_FP_ESTABLISHMENT_V

Line 187: FROM xle_fp_establishment_v est,

183: CURSOR c_establishment_reg_num (c_ptp_id number, c_tax_reg_num varchar2) IS
184: SELECT regt.registration_number
185: FROM zx_registrations regt
186: where regt.party_tax_profile_id = (SELECT ptpp.party_tax_profile_id
187: FROM xle_fp_establishment_v est,
188: xle_fp_establishment_v estp,
189: zx_party_tax_profile ptp,
190: zx_party_tax_profile ptpp
191: where estp.party_id = ptpp.party_id

Line 188: xle_fp_establishment_v estp,

184: SELECT regt.registration_number
185: FROM zx_registrations regt
186: where regt.party_tax_profile_id = (SELECT ptpp.party_tax_profile_id
187: FROM xle_fp_establishment_v est,
188: xle_fp_establishment_v estp,
189: zx_party_tax_profile ptp,
190: zx_party_tax_profile ptpp
191: where estp.party_id = ptpp.party_id
192: and estp.legal_entity_id = est.legal_entity_id

Line 323: FROM xle_fp_establishment_v

319: ELSIF p_party_type_code = 'LEGAL_ESTABLISHMENT' THEN
320:
321: SELECT distinct establishment_name
322: INTO l_party_name
323: FROM xle_fp_establishment_v
324: WHERE party_id = l_party_id;
325:
326: x_party_name_token := x_party_name_token ||' '|| l_party_name;
327: x_party_site_name_token := NULL;

Line 749: FROM xle_fp_establishment_v est,

745: where ptp.rep_registration_number = p_tax_reg_num
746: and ptp.party_type_code = p_party_type_code
747: and ptp.party_tax_profile_id <> p_ptp_id
748: and not exists (SELECT 1
749: FROM xle_fp_establishment_v est,
750: xle_fp_establishment_v estp,
751: zx_party_tax_profile ptpp
752: where ptpp.party_tax_profile_id = p_ptp_id
753: and estp.party_id = ptpp.party_id

Line 750: xle_fp_establishment_v estp,

746: and ptp.party_type_code = p_party_type_code
747: and ptp.party_tax_profile_id <> p_ptp_id
748: and not exists (SELECT 1
749: FROM xle_fp_establishment_v est,
750: xle_fp_establishment_v estp,
751: zx_party_tax_profile ptpp
752: where ptpp.party_tax_profile_id = p_ptp_id
753: and estp.party_id = ptpp.party_id
754: and estp.legal_entity_id = est.legal_entity_id

Line 777: FROM xle_fp_establishment_v

773: p_error_buffer := 'ZX_REG_NUM_DUPLICATE';
774:
775: SELECT distinct establishment_name
776: INTO l_party_name
777: FROM xle_fp_establishment_v
778: WHERE party_id = l_party_id;
779:
780: if x_party_name_token is null then
781: x_party_name_token := l_party_name;