DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 992: iby_pay_service_requests IPSR ,

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
996: AND DECODE(IPSR.payment_service_request_id, NULL,