APPS.POS_PARTY_MERGE_PKG dependencies on POS_PRODUCT_SERVICE_REQUESTS

Line 64: FROM pos_product_service_requests ppsr, pos_supplier_mappings psm

60: AND pcar.request_status = 'PENDING';
61:
62: CURSOR l_product_service IS
63: SELECT 1
64: FROM pos_product_service_requests ppsr, pos_supplier_mappings psm
65: WHERE psm.party_id = p_party_id
66: AND psm.mapping_id = ppsr.mapping_id
67: AND ppsr.request_status = 'PENDING';
68: