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 3489: FROM hz_org_contacts hzoc, hz_relationships hzr

3485: -- Cursor for getting contact_party_id and rel_party_id
3486: CURSOR C_get_contact_info
3487: IS
3488: SELECT decode(subject_type,'PERSON',subject_id, object_id) contact_party_id, party_id
3489: FROM hz_org_contacts hzoc, hz_relationships hzr
3490: WHERE hzoc.org_contact_id = l_org_contact_id
3491: AND hzr.relationship_id = hzoc.party_relationship_id
3492: and hzr.relationship_code = 'CONTACT_OF';
3493:

Line 3517: FROM hz_relationships hzr

3513: -- Cursor for getting rel_party_id
3514: CURSOR C_get_rel_party_id(p_contact_party_id number, p_party_id number)
3515: IS
3516: SELECT party_id
3517: FROM hz_relationships hzr
3518: WHERE hzr.relationship_code in ('CONTACT_OF','EMPLOYEE_OF')
3519: AND subject_id in (p_contact_party_id, p_party_id)
3520: AND object_id in (p_contact_party_id, p_party_id)
3521: AND hzr.status = 'A'