APPS.ZX_EXTRACT_PKG dependencies on XLE_ETB_PROFILES

Line 2797: xle_etb_profiles etb,

2793: (rel.subject_id,
2794: rel.object_id),
2795: hzpp.person_pre_name_adjunct --title,
2796: FROM HZ_PARTIES per,
2797: xle_etb_profiles etb,
2798: HZ_RELATIONSHIPS rel,
2799: hz_person_profiles hzpp,
2800: HZ_ORG_CONTACTS con
2801: -- XLE_CONTACT_LEGAL_ROLES rol

Line 2999: xle_etb_profiles xlep

2995: --get ptp id for HQ of the LE
2996: SELECT ptp.party_id
2997: INTO l_hq_party_id
2998: FROM zx_party_tax_profile ptp,
2999: xle_etb_profiles xlep
3000: WHERE ptp.party_id = xlep.party_id
3001: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
3002: AND xlep.legal_entity_id = p_trl_global_variables_rec.legal_entity_id
3003: AND xlep.main_establishment_flag = 'Y';