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

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

118: Where PAA.Project_Accum_id In
119: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
120: Where Pah.Project_id = x_project_id and
121: pah.Resource_list_member_id = x_resource_list_Member_id and
122: Pah.Task_id in ( select 0 from sys.dual union
123: Select Pt.Task_Id from PA_TASKS pt
124: start with pt.task_id = x_task_id
125: connect by prior pt.parent_task_id = pt.task_id));
126: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 162: From Dual;

158: If v_noof_tasks > 0 Then
159: For i in 1..v_noof_tasks LOOP
160: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval
161: into V_Accum_id
162: From Dual;
163: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
164: (X_project_id,
165: v_task_array(i),
166: x_resource_list_id ,

Line 204: From Dual;

200: Open Proj_Res_level_Cur;
201: Fetch Proj_Res_level_Cur Into V_Accum_Id;
202: If Proj_Res_level_Cur%NOTFOUND Then
203: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
204: From Dual;
205: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
206: (X_project_id,
207: 0,
208: x_resource_list_id ,

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

361: Where PAA.Project_Accum_id In
362: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
363: Where Pah.Project_id = x_project_id and
364: pah.Resource_list_member_id = x_resource_list_Member_id and
365: Pah.Task_id in (select 0 from sys.dual union
366: Select Pt.Task_Id from PA_TASKS pt
367: start with pt.task_id = x_task_id
368: connect by prior pt.parent_task_id = pt.task_id));
369: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 404: From Dual;

400:
401: If v_noof_tasks > 0 Then
402: For i in 1..v_noof_tasks LOOP
403: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
404: From Dual;
405: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
406: (X_project_id,
407: v_task_array(i),
408: x_resource_list_id ,

Line 446: From Dual;

442: Open Proj_Res_level_Cur;
443: Fetch Proj_Res_level_Cur Into V_Accum_Id;
444: If Proj_Res_level_Cur%NOTFOUND Then
445: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
446: From Dual;
447: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
448: (X_project_id,
449: 0,
450: x_resource_list_id ,

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

605:
606: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
607: Where Pah.Project_id = x_project_id and
608: pah.Resource_list_member_id = x_resource_list_Member_id and
609: Pah.Task_id in (select 0 from sys.dual union
610: Select Pt.Task_Id from PA_TASKS pt
611: start with pt.task_id = x_task_id
612: connect by prior pt.parent_task_id = pt.task_id));
613: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 648: From Dual;

644:
645: If v_noof_tasks > 0 Then
646: For i in 1..v_noof_tasks LOOP
647: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
648: From Dual;
649: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
650: (X_project_id,
651: v_task_array(i),
652: x_resource_list_id ,

Line 690: From Dual;

686: Open Proj_Res_level_Cur;
687: Fetch Proj_Res_level_Cur Into V_Accum_Id;
688: If Proj_Res_level_Cur%NOTFOUND Then
689: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
690: From Dual;
691: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
692: (X_project_id,
693: 0,
694: x_resource_list_id ,

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

848: Where PAA.Project_Accum_id In
849: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
850: Where Pah.Project_id = x_project_id and
851: pah.Resource_list_member_id = x_resource_list_Member_id and
852: Pah.Task_id in (select 0 from sys.dual union
853: Select Pt.Task_Id from PA_TASKS pt
854: start with pt.task_id = x_task_id
855: connect by prior pt.parent_task_id = pt.task_id));
856: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 891: From Dual;

887:
888: If v_noof_tasks > 0 Then
889: For i in 1..v_noof_tasks LOOP
890: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
891: From Dual;
892: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
893: (X_project_id,
894: v_task_array(i),
895: x_resource_list_id ,

Line 933: From Dual;

929: Open Proj_Res_level_Cur;
930: Fetch Proj_Res_level_Cur Into V_Accum_Id;
931: If Proj_Res_level_Cur%NOTFOUND Then
932: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
933: From Dual;
934: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
935: (X_project_id,
936: 0,
937: x_resource_list_id ,

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

1085: Where PAA.Project_Accum_id In
1086: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1087: Where Pah.Project_id = x_project_id and
1088: pah.Resource_list_member_id = x_resource_list_Member_id and
1089: Pah.Task_id in (select 0 from sys.dual union
1090: Select Pt.Task_Id from PA_TASKS pt
1091: start with pt.task_id = x_task_id
1092: connect by prior pt.parent_task_id = pt.task_id));
1093: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 1128: From Dual;

1124:
1125: If v_noof_tasks > 0 Then
1126: For i in 1..v_noof_tasks LOOP
1127: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1128: From Dual;
1129: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
1130: (X_project_id,
1131: v_task_array(i),
1132: x_resource_list_id ,

Line 1169: From Dual;

1165: Open Proj_Res_level_Cur;
1166: Fetch Proj_Res_level_Cur Into V_Accum_Id;
1167: If Proj_Res_level_Cur%NOTFOUND Then
1168: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1169: From Dual;
1170: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
1171: (X_project_id,
1172: 0,
1173: x_resource_list_id ,