APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on POS_CONTACT_REQUESTS

Line 996: from pos_contact_requests pcr,

992: and hzr.subject_type ='PERSON'
993: and hzr.object_type = 'ORGANIZATION'
994: and hzr.status = 'A'
995: and hp.party_id not in (select contact_party_id
996: from pos_contact_requests pcr,
997: pos_supplier_mappings psm
998: where pcr.request_status='PENDING'
999: and psm.mapping_id = pcr.mapping_id
1000: and psm.PARTY_ID = l_dup_from_party_id /* :2 bug 9604355 */