DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_RELATIONSHIPS

Line 156: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel

152:
153: CURSOR c_party_rels IS
154: SELECT r.party_id, r.object_id, o.party_name, r.subject_id, s.party_name,
155: rel.party_number, rel.party_name
156: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel
157: WHERE (r.subject_id = p_party_id OR r.object_id = p_party_id)
158: AND r.party_id IS NOT NULL
159: AND r.subject_table_name = 'HZ_PARTIES'
160: AND r.object_table_name = 'HZ_PARTIES'

Line 655: FROM hz_relationships rel,

651: RETURN NUMBER IS
652: l_party_id NUMBER;
653: CURSOR c IS
654: SELECT rel.party_id
655: FROM hz_relationships rel,
656: hz_org_contacts cont
657: WHERE cont.request_id = p_request_id
658: AND cont.orig_system_reference = p_orig_system_contact_ref
659: AND cont.party_relationship_id = rel.relationship_id

Line 680: FROM hz_relationships rel,

676: RETURN NUMBER IS
677: l_prel_id NUMBER;
678: CURSOR c is
679: SELECT rel.relationship_id
680: FROM hz_relationships rel,
681: hz_org_contacts cont
682: WHERE cont.request_id = p_request_id
683: AND cont.orig_system_reference = p_orig_system_contact_ref
684: AND cont.party_relationship_id = rel.relationship_id