DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_ORG_CONTACTS

Line 656: hz_org_contacts cont

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
660: AND rel.subject_table_name = 'HZ_PARTIES'

Line 681: hz_org_contacts cont

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
685: AND rel.subject_table_name = 'HZ_PARTIES'