DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 991: FROM ap_inv_selection_criteria_all AISC,

987: is
988: -- check if any unconfirmed payment batches
989: cursor c_uncnf_pmt_batch_exists is
990: SELECT 'Y'
991: FROM ap_inv_selection_criteria_all AISC,
992: iby_pay_service_requests IPSR ,
993: ap_selected_invoices_all ASI
994: WHERE IPSR.call_app_pay_service_req_code (+) = AISC.checkrun_name
995: AND trunc(aisc.check_date) between g_period_start_date and g_period_end_date