APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on POS_SUPPLIER_MAPPINGS
Line 795: pos_supplier_mappings psm
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
799: and contact_party_id is not null