APPS.IBY_PAYMENT_MANAGER_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 117: FROM iby_pay_service_requests ipsr ,

113: aisc.status ,
114: aisc.checkrun_id ,
115: aisc.checkrun_name ,
116: aisc.creation_date
117: FROM iby_pay_service_requests ipsr ,
118: ap_inv_selection_criteria_all aisc
119: WHERE ipsr.call_app_pay_service_req_code(+) = aisc.checkrun_name;
120: --AND process_type = 'STANDARD' ;
121: BEGIN

Line 138: --Handling everything with iby_pay_service_requests first.

134: FOR c_rec_snap IN c_psr_snapshot
135: LOOP
136:
137: /* IBY NEED ACTION */
138: --Handling everything with iby_pay_service_requests first.
139: --For IBY_PAY_SERVICE_REQUESTS.
140: IF c_rec_snap.payment_service_request_status IN ('INFORMATION_REQUIRED' , 'PENDING_REVIEW_DOC_VAL_ERRORS','PENDING_REVIEW_PMT_VAL_ERRORS', 'PENDING_REVIEW') THEN
141: l_need_action := l_need_action + 1;
142: --For records in ap_inv_selection_criteria_all but not in iby_pay_service_request. For PPR which are still before build.

Line 139: --For IBY_PAY_SERVICE_REQUESTS.

135: LOOP
136:
137: /* IBY NEED ACTION */
138: --Handling everything with iby_pay_service_requests first.
139: --For IBY_PAY_SERVICE_REQUESTS.
140: IF c_rec_snap.payment_service_request_status IN ('INFORMATION_REQUIRED' , 'PENDING_REVIEW_DOC_VAL_ERRORS','PENDING_REVIEW_PMT_VAL_ERRORS', 'PENDING_REVIEW') THEN
141: l_need_action := l_need_action + 1;
142: --For records in ap_inv_selection_criteria_all but not in iby_pay_service_request. For PPR which are still before build.
143: ELSIF c_rec_snap.payment_service_request_status IS NULL AND c_rec_snap.status IN ('REVIEW', 'MISSING RATES' ) THEN