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_RES dependencies on DUAL

Line 96: Pah.Task_id in (select 0 from sys.dual union

92: Where PAA.Project_Accum_id In
93: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
94: Where Pah.Project_id = x_project_id and
95: pah.Resource_list_member_id = x_resource_list_Member_id and
96: Pah.Task_id in (select 0 from sys.dual union
97: Select Pt.Task_Id from PA_TASKS pt
98: start with pt.task_id = x_task_id
99: connect by prior pt.parent_task_id = pt.task_id));
100: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 114: Pah.Task_id in (select 0 from sys.dual union

110: Where PAA.Project_Accum_id In
111: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
112: Where Pah.Project_id = x_project_id and
113: pah.Resource_list_member_id = x_resource_list_Member_id and
114: Pah.Task_id in (select 0 from sys.dual union
115: Select Pt.Task_Id from PA_TASKS pt
116: start with pt.task_id = x_task_id
117: connect by prior pt.parent_task_id = pt.task_id));
118: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 224: Pah.Task_id in (select 0 from sys.dual union

220: Where PAA.Project_Accum_id In
221: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
222: Where Pah.Project_id = x_project_id and
223: pah.Resource_list_member_id = x_resource_list_Member_id and
224: Pah.Task_id in (select 0 from sys.dual union
225: Select Pt.Task_Id from PA_TASKS pt
226: start with pt.task_id = x_task_id
227: connect by prior pt.parent_task_id = pt.task_id));
228: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 242: Pah.Task_id in (select 0 from sys.dual

238: Where PAA.Project_Accum_id In
239: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
240: Where Pah.Project_id = x_project_id and
241: pah.Resource_list_member_id = x_resource_list_Member_id and
242: Pah.Task_id in (select 0 from sys.dual
243: union Select Pt.Task_Id from PA_TASKS pt
244: start with pt.task_id = x_task_id
245: connect by prior pt.parent_task_id = pt.task_id));
246: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 338: Pah.Task_id in (select 0 from sys.dual union

334: Where PAA.Project_Accum_id In
335: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
336: Where Pah.Project_id = x_project_id and
337: pah.Resource_list_member_id = x_resource_list_Member_id and
338: Pah.Task_id in (select 0 from sys.dual union
339: Select Pt.Task_Id from PA_TASKS pt
340: start with pt.task_id = x_task_id
341: connect by prior pt.parent_task_id = pt.task_id));
342: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 355: Pah.Task_id in (select 0 from sys.dual union

351: Where PAA.Project_Accum_id In
352: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
353: Where Pah.Project_id = x_project_id and
354: pah.Resource_list_member_id = x_resource_list_Member_id and
355: Pah.Task_id in (select 0 from sys.dual union
356: Select Pt.Task_Id from PA_TASKS pt
357: start with pt.task_id = x_task_id
358: connect by prior pt.parent_task_id = pt.task_id));
359: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 449: Pah.Task_id in (select 0 from sys.dual union

445: Where PAA.Project_Accum_id In
446: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
447: Where Pah.Project_id = x_project_id and
448: pah.Resource_list_member_id = x_resource_list_Member_id and
449: Pah.Task_id in (select 0 from sys.dual union
450: Select Pt.Task_Id from PA_TASKS pt
451: start with pt.task_id = x_task_id
452: connect by prior pt.parent_task_id = pt.task_id));
453: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 466: Pah.Task_id in (select 0 from sys.dual union

462: Where PAA.Project_Accum_id In
463: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
464: Where Pah.Project_id = x_project_id and
465: pah.Resource_list_member_id = x_resource_list_Member_id and
466: Pah.Task_id in (select 0 from sys.dual union
467: Select Pt.Task_Id from PA_TASKS pt
468: start with pt.task_id = x_task_id
469: connect by prior pt.parent_task_id = pt.task_id));
470: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 550: Pah.Task_id in (select 0 from sys.dual union

546: Where PAA.Project_Accum_id In
547: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
548: Where Pah.Project_id = x_project_id and
549: pah.Resource_list_member_id = x_resource_list_Member_id and
550: Pah.Task_id in (select 0 from sys.dual union
551: Select Pt.Task_Id from PA_TASKS pt
552: start with pt.task_id = x_task_id
553: connect by prior pt.parent_task_id = pt.task_id));
554: x_recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 566: Pah.Task_id in (select 0 from sys.dual union

562: Where PAA.Project_Accum_id In
563: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
564: Where Pah.Project_id = x_project_id and
565: pah.Resource_list_member_id = x_resource_list_Member_id and
566: Pah.Task_id in (select 0 from sys.dual union
567: Select Pt.Task_Id from PA_TASKS pt
568: start with pt.task_id = x_task_id
569: connect by prior pt.parent_task_id = pt.task_id));
570: x_recs_processed := Recs_processed + SQL%ROWCOUNT;