DBA Data[Home] [Help]

APPS.IBY_PAYMENT_MANAGER_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 118: ap_inv_selection_criteria_all aisc

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
122: IF(g_psr_snapshot_table.EXISTS(p_snapshot_code) AND g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count IS NOT NULL) THEN

Line 142: --For records in ap_inv_selection_criteria_all but not in iby_pay_service_request. For PPR which are still before build.

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
144: l_need_action := l_need_action + 1;
145: /* IBY NEED ACTION */
146: /* IBY IN PROCESS. */