APPS.ZX_EXTRACT_PKG dependencies on HZ_PARTIES

Line 2307: FROM HZ_PARTIES per,

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,
2308: xle_entity_profiles xep,
2309: HZ_RELATIONSHIPS rel,
2310: hz_person_profiles hzpp,
2311: HZ_ORG_CONTACTS con

Line 2318: AND rel.subject_table_name = 'HZ_PARTIES'

2314: AND rel.object_id = xep.party_id
2315: AND per.party_id = hzpp.party_id
2316: AND rel.relationship_type = 'CONTACT'
2317: AND rel.directional_flag = 'F'
2318: AND rel.subject_table_name = 'HZ_PARTIES'
2319: AND rel.subject_type = 'PERSON'
2320: AND rel.subject_id = per.party_id
2321: -- AND rel.subject_id = rol.contact_party_id
2322: -- AND rel.object_id = rol.le_etb_party_id

Line 2323: AND rel.object_table_name = 'HZ_PARTIES'

2319: AND rel.subject_type = 'PERSON'
2320: AND rel.subject_id = per.party_id
2321: -- AND rel.subject_id = rol.contact_party_id
2322: -- AND rel.object_id = rol.le_etb_party_id
2323: AND rel.object_table_name = 'HZ_PARTIES'
2324: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE)
2325: AND rel.relationship_id = con.party_relationship_id
2326: AND xep.legal_entity_id = c_rep_entity_id
2327: UNION

Line 2335: FROM HZ_PARTIES per,

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,
2336: xle_etb_profiles etb,
2337: HZ_RELATIONSHIPS rel,
2338: hz_person_profiles hzpp,
2339: HZ_ORG_CONTACTS con

Line 2346: AND rel.subject_table_name = 'HZ_PARTIES'

2342: AND rel.object_id = etb.party_id
2343: AND per.party_id = hzpp.party_id
2344: AND rel.relationship_type = 'CONTACT'
2345: AND rel.directional_flag = 'F'
2346: AND rel.subject_table_name = 'HZ_PARTIES'
2347: AND rel.subject_type = 'PERSON'
2348: AND rel.subject_id = per.party_id
2349: --AND rel.subject_id = rol.contact_party_id
2350: --AND rel.object_id = rol.le_etb_party_id

Line 2351: AND rel.object_table_name = 'HZ_PARTIES'

2347: AND rel.subject_type = 'PERSON'
2348: AND rel.subject_id = per.party_id
2349: --AND rel.subject_id = rol.contact_party_id
2350: --AND rel.object_id = rol.le_etb_party_id
2351: AND rel.object_table_name = 'HZ_PARTIES'
2352: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE)
2353: AND rel.relationship_id = con.party_relationship_id
2354: AND etb.establishment_id = c_rep_entity_id ;
2355: