DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_BUDGETS dependencies on DUAL

Line 172: UNION select to_number(X_Proj_accum_id) from sys.dual);

168: pah.Resource_list_member_id = 0 and
169: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
170: start with pt.task_id = x_task_id
171: connect by prior pt.parent_task_id = pt.task_id)
172: UNION select to_number(X_Proj_accum_id) from sys.dual);
173:
174: Recs_processed := Recs_processed + SQL%ROWCOUNT;
175:
176: x_recs_processed := Recs_processed;

Line 282: UNION select to_number(X_Proj_accum_id) from sys.dual);

278: pah.Resource_list_member_id = 0 and
279: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
280: start with pt.task_id = x_task_id
281: connect by prior pt.parent_task_id = pt.task_id)
282: UNION select to_number(X_Proj_accum_id) from sys.dual);
283:
284: Recs_processed := Recs_processed + SQL%ROWCOUNT;
285:
286: x_recs_processed := Recs_processed;

Line 391: UNION select to_number(X_Proj_accum_id) from sys.dual);

387: pah.Resource_list_member_id = 0 and
388: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
389: start with pt.task_id = x_task_id
390: connect by prior pt.parent_task_id = pt.task_id)
391: UNION select to_number(X_Proj_accum_id) from sys.dual);
392: Recs_processed := Recs_processed + SQL%ROWCOUNT;
393:
394: x_recs_processed := Recs_processed;
395: -- Restore the old x_err_stack;

Line 489: UNION select to_number(X_Proj_accum_id) from sys.dual);

485: pah.Resource_list_member_id = 0 and
486: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
487: start with pt.task_id = x_task_id
488: connect by prior pt.parent_task_id = pt.task_id)
489: UNION select to_number(X_Proj_accum_id) from sys.dual);
490: Recs_processed := Recs_processed + SQL%ROWCOUNT;
491:
492: x_recs_processed := Recs_processed;
493:

Line 587: UNION select to_number(X_Proj_accum_id) from sys.dual);

583: pah.Resource_list_member_id = 0 and
584: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
585: start with pt.task_id = x_task_id
586: connect by prior pt.parent_task_id = pt.task_id)
587: UNION select to_number(X_Proj_accum_id) from sys.dual);
588: Recs_processed := Recs_processed + SQL%ROWCOUNT;
589:
590: -- Restore the old x_err_stack;
591:

Line 672: UNION select to_number(X_Proj_accum_id) from sys.dual);

668: pah.Resource_list_member_id = 0 and
669: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
670: start with pt.task_id = x_task_id
671: connect by prior pt.parent_task_id = pt.task_id)
672: UNION select to_number(X_Proj_accum_id) from sys.dual);
673: Recs_processed := Recs_processed + SQL%ROWCOUNT;
674:
675: -- Restore the old x_err_stack;
676: