APPS.ZX_EXTRACT_PKG dependencies on XLE_ENTITY_PROFILES

Line 2295: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'

2291: xle_auth.authority_name
2292: FROM xle_legalauth_v xle_auth,
2293: xle_registrations xle_reg
2294: WHERE xle_reg.source_id = c_rep_entity_id
2295: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
2296: AND xle_auth.legalauth_id = xle_reg.issuing_authority_id
2297: AND xle_reg.identifying_flag = 'Y';
2298:
2299: CURSOR c_legal_contact_info (c_rep_entity_id number) IS

Line 2308: xle_entity_profiles xep,

2304: (rel.subject_id,
2305: rel.object_id),
2306: hzpp.person_pre_name_adjunct -- title
2307: FROM HZ_PARTIES per,
2308: xle_entity_profiles xep,
2309: HZ_RELATIONSHIPS rel,
2310: hz_person_profiles hzpp,
2311: HZ_ORG_CONTACTS con
2312: --XLE_CONTACT_LEGAL_ROLES rol