DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_SELECTED_INVOICES_ALL

Line 1219: ap_selected_invoices_all ASI

1215: cursor c_uncnf_pmt_batch_exists is
1216: SELECT 'Y'
1217: FROM ap_inv_selection_criteria_all AISC,
1218: iby_pay_service_requests IPSR ,
1219: ap_selected_invoices_all ASI
1220: WHERE IPSR.call_app_pay_service_req_code (+) = AISC.checkrun_name
1221: AND trunc(aisc.check_date) between g_period_start_date and g_period_end_date
1222: AND DECODE(IPSR.payment_service_request_id, NULL,
1223: AISC.status,