APPS.PA_MC_BILLING_PVT dependencies on DUAL

Line 319: FROM dual

315: ------------------------------------------------------------------------------ */
316:
317: CURSOR csr_rollup IS
318: SELECT 'P'
319: FROM dual
320: WHERE p_task_id is null
321: UNION
322: SELECT 'T'
323: FROM pa_tasks

Line 338: FROM dual

334: from pa_tasks
335: where parent_task_id = p_task_id)
336: UNION
337: SELECt 'L'
338: FROM dual
339: WHERE p_task_id is not null
340: AND not exists (select 'X'
341: from pa_tasks
342: where parent_task_id = p_task_id);