[Home] [Help]
4287: /* This Cursor checks if the project has supplier invoices */
4288: CURSOR C_CHECK_AP_INVOICE_EXISTS IS
4289: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4290: (SELECT NULL
4291: FROM AP_INVOICES_ALL
4292: WHERE PROJECT_ID=p_project_id);
4293:
4294: /* This Cursor checks if the project has supplier invoices distribution */
4295: CURSOR C_CHECK_AP_INVOICE_DIST_EXISTS IS