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_MAINT_PROJECT_ACCUMS dependencies on GL_PERIODS

Line 62: -- table is replaced by GL_PERIODS. Accordingly the condition to join

58: -- by LTRIM(RTRIM(SUBSTR(USERENV('CLIENT_INFO'),1,10)))
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.

Line 64: -- and period_type is used to join GL_PERIODS and PA_IMPLIMENTATIONS

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.
68: --

Line 72: -- and PA_Txn_Accum_Cur, removed the check for 'PERIOD_TYPE' between GL_PERIODS

68: --
69: -- 05-Aug-2005 sacgupta Bug 4532088. Added trunc to the condition trunc(gps.END_DATE) <= x_current_end_date
70: -- in procedure Process_Txn_Accum, cursors Res_accum_Cur and PA_Txn_Accum_Cur
71: -- 30-Sep-2005 pkanupar Bug4631058: In the procedure PROCESS_TXN_ACCUM, in the cursors Res_accum_Cur
72: -- and PA_Txn_Accum_Cur, removed the check for 'PERIOD_TYPE' between GL_PERIODS
73: -- and PA_IMPLIMENTATIONS.
74: -- 16-Feb-2006 djoseph Bug 5019025 : In the procedure PROCESS_TXN_ACCUM, in the cursors Res_accum_Cur
75: -- and PA_Txn_Accum_Cur, removed the decode that was used to join the period_name
76: -- based on the value of x_impl_opt.

Line 354: GL_PERIODS GPS,

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,
358: PA_RESOURCE_LIST_MEMBERS Parl

Line 410: GL_PERIODS GPS,

406: Par.UNIT_OF_MEASURE,
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

Line 463: GL_PERIODS GPS,

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(+)
467: and (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')