[Home] [Help]
59: -- 03-may-2004 dkala Added migration_code <> 'N'.
60: -- 07-Mar-2004 sacupta Bug 4195598. Cursors Res_accum_Cur and PA_Txn_Accum_Cur are modified
61: -- in procedure PROCESS_TXN_ACCUM. The reference to GL_PERIOD_STATUSES
62: -- table is replaced by GL_PERIODS. Accordingly the condition to join
63: -- this table with PA_IMPLEMENTATIONS has changed. Now period_set_name
64: -- and period_type is used to join GL_PERIODS and PA_IMPLIMENTATIONS
65: -- table as against application_id and set_of_books_id that was used
66: -- previously to join GL_PERIOD_STATUSES with PA_IMPLEMENTAIONS.
67: -- Refer bug for further details.
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,
189: PA_RESOURCE_LIST_MEMBERS Parl
190: Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
241: 0 wbs_level
242: FROM
243: PA_TXN_ACCUM PTA,
244: GL_PERIOD_STATUSES GPS,
245: PA_IMPLEMENTATIONS PI,
246: PA_RESOURCE_ACCUM_DETAILS Para,
247: PA_RESOURCES Par,
248: PA_RESOURCE_LIST_MEMBERS Parl
249: Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
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(+)
304: and (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
305: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
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,
358: PA_RESOURCE_LIST_MEMBERS Parl
359: Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
407: 0 wbs_level
408: FROM
409: PA_TXN_ACCUM PTA,
410: GL_PERIODS GPS,
411: PA_IMPLEMENTATIONS PI,
412: PA_RESOURCE_ACCUM_DETAILS Para,
413: PA_RESOURCES Par,
414: PA_RESOURCE_LIST_MEMBERS Parl
415: Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
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(+)
467: and (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
468: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')