APPS.AS_IMPORT_SL_PVT dependencies on HZ_RELATIONSHIPS

Line 2095: from hz_relationships

2091: -- if the relationship exists, then we can assume that the
2092: -- org contact rec exists.
2093: Begin
2094: Select party_id into pI.rel_party_id
2095: from hz_relationships
2096: where subject_id = pI.contact_party_id
2097: and object_id = pI.party_id
2098: and subject_table_name = 'HZ_PARTIES'
2099: and object_table_name = 'HZ_PARTIES'

Line 2103: -- ffang 073101, use hz_relationships instead of hz_party_relationships

2099: and object_table_name = 'HZ_PARTIES'
2100: and relationship_code = 'CONTACT_OF';
2101:
2102: /* *****
2103: -- ffang 073101, use hz_relationships instead of hz_party_relationships
2104: Select party_id into pI.rel_party_id
2105: from hz_party_relationships
2106: where subject_id = pI.contact_party_id
2107: and object_id = pI.party_id

Line 3470: FROM hz_org_contacts hzoc, hz_relationships hzr

3466: -- Cursor for getting contact_party_id and rel_party_id
3467: CURSOR C_get_contact_info
3468: IS
3469: SELECT decode(subject_type,'PERSON',subject_id, object_id) contact_party_id, party_id
3470: FROM hz_org_contacts hzoc, hz_relationships hzr
3471: WHERE hzoc.org_contact_id = l_org_contact_id
3472: AND hzr.relationship_id = hzoc.party_relationship_id
3473: and hzr.relationship_code = 'CONTACT_OF';
3474:

Line 3498: FROM hz_relationships hzr

3494: -- Cursor for getting rel_party_id
3495: CURSOR C_get_rel_party_id(p_contact_party_id number, p_party_id number)
3496: IS
3497: SELECT party_id
3498: FROM hz_relationships hzr
3499: WHERE hzr.relationship_code in ('CONTACT_OF','EMPLOYEE_OF')
3500: AND subject_id in (p_contact_party_id, p_party_id)
3501: AND object_id in (p_contact_party_id, p_party_id)
3502: AND hzr.status = 'A'