APPS.ZX_EXTRACT_PKG dependencies on XLE_ETB_PROFILES

Line 2336: xle_etb_profiles etb,

2332: (rel.subject_id,
2333: rel.object_id),
2334: hzpp.person_pre_name_adjunct --title,
2335: FROM HZ_PARTIES per,
2336: xle_etb_profiles etb,
2337: HZ_RELATIONSHIPS rel,
2338: hz_person_profiles hzpp,
2339: HZ_ORG_CONTACTS con
2340: -- XLE_CONTACT_LEGAL_ROLES rol

Line 2540: xle_etb_profiles xlep

2536: --get ptp id for HQ of the LE
2537: SELECT ptp.party_id
2538: INTO l_hq_party_id
2539: FROM zx_party_tax_profile ptp,
2540: xle_etb_profiles xlep
2541: WHERE ptp.party_id = xlep.party_id
2542: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
2543: AND xlep.legal_entity_id = p_trl_global_variables_rec.legal_entity_id
2544: AND xlep.main_establishment_flag = 'Y';