APPS.AP_PAYMENT_UTIL_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 583: FROM iby_pay_service_requests ipsr

579: cep_standard.init_security;
580:
581: SELECT count(*)
582: INTO l_count3
583: FROM iby_pay_service_requests ipsr
584: , ap_inv_selection_criteria_all aisca
585: WHERE aisca.checkrun_id = p_checkrun_id
586: AND aisca.checkrun_name = ipsr.call_app_pay_service_req_code;
587:

Line 1157: /* Bug 11063950 : Populating request_id from ap_inv_selection_criteria_all instead of iby_pay_service_requests */

1153: */
1154: RETURN 'YES';
1155: ELSE --IBY
1156:
1157: /* Bug 11063950 : Populating request_id from ap_inv_selection_criteria_all instead of iby_pay_service_requests */
1158:
1159: /* Commenting out for Bug 11063950 */
1160: /* SELECT request_id,
1161: payment_service_request_status

Line 1163: FROM iby_pay_service_requests

1159: /* Commenting out for Bug 11063950 */
1160: /* SELECT request_id,
1161: payment_service_request_status
1162: INTO l_request_id,l_psr_status
1163: FROM iby_pay_service_requests
1164: WHERE payment_service_request_id = p_psr_id; */
1165:
1166: SELECT request_id
1167: INTO l_request_id