DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 1217: FROM ap_inv_selection_criteria_all AISC,

1213: is
1214: -- check if any unconfirmed payment batches
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