eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROCESS_ACCUM_ACTUALS dependencies on DUAL

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

81: pah.Resource_list_member_id = 0 and
82: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
83: start with pt.task_id = x_task_id
84: connect by prior pt.parent_task_id = pt.task_id) UNION
85: select to_number(X_Proj_accum_id) from sys.dual);
86:
87: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
88:
89: END IF;

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

102: pah.Resource_list_member_id = 0 and
103: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
104: start with pt.task_id = x_task_id
105: connect by prior pt.parent_task_id = pt.task_id) UNION
106: select to_number(X_Proj_accum_id) from sys.dual);
107:
108: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
109:
110: END IF;

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

194: pah.Resource_list_member_id = 0 and
195: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
196: start with pt.task_id = x_task_id
197: connect by prior pt.parent_task_id = pt.task_id)
198: UNION select to_number(X_Proj_accum_id) from sys.dual);
199:
200: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
201: END IF;
202: IF(x_revenue_flag = 'Y') THEN

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

214: pah.Resource_list_member_id = 0 and
215: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
216: start with pt.task_id = x_task_id
217: connect by prior pt.parent_task_id = pt.task_id)
218: UNION select to_number(X_Proj_accum_id) from sys.dual);
219:
220: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
221: END IF;
222: -- Restore the old x_err_stack;

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

298: pah.Resource_list_member_id = 0 and
299: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
300: start with pt.task_id = x_task_id
301: connect by prior pt.parent_task_id = pt.task_id)
302: UNION select to_number(X_Proj_accum_id) from sys.dual);
303:
304: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
305: END IF;
306: IF(x_revenue_flag = 'Y') THEN

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

317: pah.Resource_list_member_id = 0 and
318: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
319: start with pt.task_id = x_task_id
320: connect by prior pt.parent_task_id = pt.task_id)
321: UNION select to_number(X_Proj_accum_id) from sys.dual);
322:
323: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
324: END IF;
325: -- Restore the old x_err_stack;

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

401: pah.Resource_list_member_id = 0 and
402: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
403: start with pt.task_id = x_task_id
404: connect by prior pt.parent_task_id = pt.task_id)
405: UNION select to_number(X_Proj_accum_id) from sys.dual);
406:
407: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
408: END IF;
409: IF(x_revenue_flag = 'Y') THEN

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

419: pah.Resource_list_member_id = 0 and
420: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
421: start with pt.task_id = x_task_id
422: connect by prior pt.parent_task_id = pt.task_id)
423: UNION select to_number(X_Proj_accum_id) from sys.dual);
424:
425: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
426: END IF;
427: -- Restore the old x_err_stack;

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

495: pah.Resource_list_member_id = 0 and
496: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
497: start with pt.task_id = x_task_id
498: connect by prior pt.parent_task_id = pt.task_id)
499: UNION select to_number(X_Proj_accum_id) from sys.dual);
500:
501: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
502: END IF;
503: IF(x_revenue_flag = 'Y') THEN

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

513: pah.Resource_list_member_id = 0 and
514: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
515: start with pt.task_id = x_task_id
516: connect by prior pt.parent_task_id = pt.task_id)
517: UNION select to_number(X_Proj_accum_id) from sys.dual);
518:
519: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
520: END IF;
521: -- Restore the old x_err_stack;