APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on POS_CONTACT_REQUESTS

Line 794: select contact_party_id from pos_contact_requests pcr,

790: and hzr.status = 'A'
791: and fu.person_party_id (+) = hp.party_id
792: and hp.party_id not in
793: (
794: select contact_party_id from pos_contact_requests pcr,
795: pos_supplier_mappings psm
796: where pcr.request_status='PENDING'
797: and psm.mapping_id = pcr.mapping_id
798: and psm.PARTY_ID = l_from_party_id --:2