DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_ACTUALS dependencies on PA_PROJECT_ACCUM_HEADERS

Line 79: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

75: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
76: LAST_UPDATE_DATE = Trunc(Sysdate),
77: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 100: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

96: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
97: LAST_UPDATE_DATE = Trunc(Sysdate),
98: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 192: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

188: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
189: LAST_UPDATE_DATE = Trunc(Sysdate),
190: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 212: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

208: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
209: LAST_UPDATE_DATE = Trunc(Sysdate),
210: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 296: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

292: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
293: LAST_UPDATE_DATE = Trunc(Sysdate),
294: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 315: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

311: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
312: LAST_UPDATE_DATE = Trunc(Sysdate),
313: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 399: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

395: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
396: LAST_UPDATE_DATE = Trunc(Sysdate),
397: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 417: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

413: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
414: LAST_UPDATE_DATE = Trunc(Sysdate),
415: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 493: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

489: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
490: LAST_UPDATE_DATE = Trunc(Sysdate),
491: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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

Line 511: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

507: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
508: LAST_UPDATE_DATE = Trunc(Sysdate),
509: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
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