DBA Data[Home] [Help]

APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on DUAL

Line 289: FROM dual

285:
286: /* check if any accepted invoice exist as the sql below is throwing no data found */
287:
288: SELECT 'T' into l_accepted_exist
289: FROM dual
290: WHERE EXISTS
291: (SELECT null
292: FROM pa_draft_invoices_all di
293: WHERE di.project_id = p_project_id

Line 1396: dual

1392: ,NULL
1393: ,NULL
1394: ,NULL
1395: FROM
1396: dual
1397: WHERE NOT EXISTS( SELECT 'x'
1398: FROM pa_bill_wrkbench_inv_temp a
1399: WHERE a.project_id = p_project_id);
1400: