DBA Data[Home] [Help]

APPS.PA_MAINT_PROJECT_ACCUMS dependencies on PA_TASKS

Line 184: PA_TASKS PT,

180: Par.UNIT_OF_MEASURE,
181: PT.wbs_level
182: FROM
183: PA_TXN_ACCUM PTA,
184: PA_TASKS PT,
185: GL_PERIOD_STATUSES GPS,
186: PA_IMPLEMENTATIONS PI,
187: PA_RESOURCE_ACCUM_DETAILS Para,
188: PA_RESOURCES Par,

Line 299: PA_TASKS PT,

295: GPS.PERIOD_YEAR,
296: nvl(PT.WBS_Level,0)
297: FROM
298: PA_TXN_ACCUM PTA,
299: PA_TASKS PT,
300: GL_PERIOD_STATUSES GPS,
301: PA_IMPLEMENTATIONS PI
302: Where PTA.Project_Id = x_project_id
303: and PTA.task_id = PT.task_id(+)

Line 353: PA_TASKS PT,

349: Par.UNIT_OF_MEASURE,
350: PT.wbs_level
351: FROM
352: PA_TXN_ACCUM PTA,
353: PA_TASKS PT,
354: GL_PERIODS GPS,
355: PA_IMPLEMENTATIONS PI,
356: PA_RESOURCE_ACCUM_DETAILS Para,
357: PA_RESOURCES Par,

Line 462: PA_TASKS PT,

458: GPS.PERIOD_YEAR,
459: nvl(PT.WBS_Level,0)
460: FROM
461: PA_TXN_ACCUM PTA,
462: PA_TASKS PT,
463: GL_PERIODS GPS,
464: PA_IMPLEMENTATIONS PI
465: Where PTA.Project_Id = x_project_id
466: and PTA.task_id = PT.task_id(+)

Line 2657: pa_tasks pt

2653:
2654: CURSOR Tasks_Cur IS
2655: SELECT task_id
2656: FROM
2657: pa_tasks pt
2658: WHERE project_id = x_project_id
2659: start with task_id = x_task_id
2660: connect by prior parent_task_id = task_id;
2661: