APPS.PA_PROCESS_ACCUM_ACTUALS dependencies on PA_TASKS

Line 82: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

78: Where PAA.Project_Accum_id In
79: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
80: Where Pah.Project_id = x_project_id and
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:

Line 103: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

99: Where PAA.Project_Accum_id In
100: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
101: Where Pah.Project_id = x_project_id and
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:

Line 195: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

191: Where PAA.Project_Accum_id In
192: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
193: Where Pah.Project_id = x_project_id and
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:

Line 215: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

211: Where PAA.Project_Accum_id In
212: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
213: Where Pah.Project_id = x_project_id and
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:

Line 299: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

295: Where PAA.Project_Accum_id In
296: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
297: Where Pah.Project_id = x_project_id and
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:

Line 318: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

314: Where PAA.Project_Accum_id In
315: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
316: Where Pah.Project_id = x_project_id and
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:

Line 402: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

398: Where PAA.Project_Accum_id In
399: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
400: Where Pah.Project_id = x_project_id and
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:

Line 420: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

416: Where PAA.Project_Accum_id In
417: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
418: Where Pah.Project_id = x_project_id and
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:

Line 496: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

492: Where PAA.Project_Accum_id In
493: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
494: Where Pah.Project_id = x_project_id and
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:

Line 514: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

510: Where PAA.Project_Accum_id In
511: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
512: Where Pah.Project_id = x_project_id and
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: