DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on HZ_ORG_CONTACTS

Line 996: FROM hz_org_contacts

992: IF (supp_contact_int_rec.org_contact_id IS NULL) THEN
993:
994: SELECT org_contact_id
995: INTO l_org_contact_id
996: FROM hz_org_contacts
997: WHERE party_relationship_id = l_relationship_id;
998:
999: UPDATE ap_sup_site_contact_int
1000: SET org_contact_id = l_org_contact_id

Line 4082: hz_org_contacts hoc

4078: SELECT 1
4079: INTO l_count
4080: FROM ap_suppliers pv,
4081: hz_relationships hzr,
4082: hz_org_contacts hoc
4083: WHERE pv.vendor_id = vendor_contact_rec.vendor_id
4084: AND hzr.relationship_type = 'CONTACT'
4085: AND hzr.relationship_code = 'CONTACT_OF'
4086: AND hzr.subject_id = vendor_contact_rec.per_party_id