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 1324: dual

1320: ,NULL
1321: ,NULL
1322: ,NULL
1323: FROM
1324: dual
1325: WHERE NOT EXISTS( SELECT 'x'
1326: FROM pa_bill_wrkbench_inv_temp a
1327: WHERE a.project_id = p_project_id);
1328: