APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_ORG_CONTACTS

Line 1078: FROM hz_org_contacts

1074: BEGIN
1075: IF l_relationship_id IS NOT NULL THEN
1076: SELECT org_contact_id
1077: INTO l_org_contact_id
1078: FROM hz_org_contacts
1079: WHERE party_relationship_id = l_relationship_id;
1080: END IF;
1081:
1082: EXCEPTION

Line 1113: FROM hz_org_contacts

1109: l_org_contact_rec.decision_maker_flag,
1110: l_org_contact_rec.job_title_code,
1111: l_org_contact_rec.reference_use_flag,
1112: l_org_contact_rec.rank
1113: FROM hz_org_contacts
1114: WHERE org_contact_id = contact_loop_c.org_contact_id;
1115:
1116: l_org_contact_rec.created_by_module := 'AP_SUPPLIERS_API';
1117: l_org_contact_rec.party_rel_rec := l_relationship_rec;