DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on XLE_CONTACT_GRP

Line 2303: XLE_CONTACT_GRP.concat_contact_roles

2299: CURSOR c_legal_contact_info (c_rep_entity_id number) IS
2300: SELECT per.party_name, -- contact_name,
2301: per.jgzz_fiscal_code, --contact_legal_id,
2302: -- rol.lookup_code, --job Title
2303: XLE_CONTACT_GRP.concat_contact_roles
2304: (rel.subject_id,
2305: rel.object_id),
2306: hzpp.person_pre_name_adjunct -- title
2307: FROM HZ_PARTIES per,

Line 2331: XLE_CONTACT_GRP.concat_contact_roles

2327: UNION
2328: SELECT per.party_name, --contact_name,
2329: per.jgzz_fiscal_code, --contact_legal_id,
2330: -- rol.lookup_code, --job Title
2331: XLE_CONTACT_GRP.concat_contact_roles
2332: (rel.subject_id,
2333: rel.object_id),
2334: hzpp.person_pre_name_adjunct --title,
2335: FROM HZ_PARTIES per,