APPS.ZX_EXTRACT_PKG dependencies on XLE_ENTITY_PROFILES

Line 2756: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'

2752: xle_auth.authority_name
2753: FROM xle_legalauth_v xle_auth,
2754: xle_registrations xle_reg
2755: WHERE xle_reg.source_id = c_rep_entity_id
2756: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
2757: AND xle_auth.legalauth_id = xle_reg.issuing_authority_id
2758: AND xle_reg.identifying_flag = 'Y';
2759:
2760: CURSOR c_legal_contact_info (c_rep_entity_id number) IS

Line 2769: xle_entity_profiles xep,

2765: (rel.subject_id,
2766: rel.object_id),
2767: hzpp.person_pre_name_adjunct -- title
2768: FROM HZ_PARTIES per,
2769: xle_entity_profiles xep,
2770: HZ_RELATIONSHIPS rel,
2771: hz_person_profiles hzpp,
2772: HZ_ORG_CONTACTS con
2773: --XLE_CONTACT_LEGAL_ROLES rol