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_ALLOC_RUN dependencies on PA_ALLOC_TXN_ACCUM_V

Line 7609: from pa_alloc_txn_accum_v pta,

7605: +nvl( pta.i_tot_billable_burdened_cost,0),
7606: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7607: +nvl(pta.i_tot_burdened_cost,0),
7608: 0) * v_pool_percent ) )
7609: from pa_alloc_txn_accum_v pta,
7610: /* FP.M : Allocation Impact : pa_txn_accum pta */
7611: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */
7612: -- pa_periods pp ,
7613: gl_period_statuses gl ,

Line 7615: /* pa_alloc_run_sources pars / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

7611: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */
7612: -- pa_periods pp ,
7613: gl_period_statuses gl ,
7614: pa_implementations imp
7615: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7616: where /* Bug 3749469
7617: pars.rule_id = p_rule_id
7618: and pars.run_id = p_run_id
7619: and pars.exclude_flag = 'N'

Line 7623: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

7619: and pars.exclude_flag = 'N'
7620: and pta.project_id = pars.project_id
7621: and pta.task_id = pars.task_id
7622: */
7623: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7624: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7625: and pta.gl_period = gl.period_name
7626: and gl.set_of_books_id = imp.set_of_books_id
7627: and gl.application_id = pa_period_process_pkg.application_id

Line 7624: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

7620: and pta.project_id = pars.project_id
7621: and pta.task_id = pars.task_id
7622: */
7623: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7624: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7625: and pta.gl_period = gl.period_name
7626: and gl.set_of_books_id = imp.set_of_books_id
7627: and gl.application_id = pa_period_process_pkg.application_id
7628: and gl.adjustment_period_flag = 'N'

Line 7679: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */

7675: +nvl( pta.i_tot_billable_burdened_cost,0),
7676: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7677: +nvl(pta.i_tot_burdened_cost,0),
7678: 0) * v_pool_percent ) )
7679: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7680: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
7681: -- pa_periods pp
7682: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7683: where /* pars.rule_id = p_rule_id

Line 7682: /* pa_alloc_run_sources pars / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

7678: 0) * v_pool_percent ) )
7679: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7680: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
7681: -- pa_periods pp
7682: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7683: where /* pars.rule_id = p_rule_id
7684: and pars.run_id = p_run_id
7685: and pars.exclude_flag = 'N'
7686: and pta.project_id = pars.project_id

Line 7689: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

7685: and pars.exclude_flag = 'N'
7686: and pta.project_id = pars.project_id
7687: and pta.task_id = pars.task_id
7688: */
7689: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7690: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7691: and pta.gl_period = p_run_period
7692: -- and pta.pa_period = pp.period_name
7693: -- and pp.gl_period_name = p_run_period

Line 7690: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */

7686: and pta.project_id = pars.project_id
7687: and pta.task_id = pars.task_id
7688: */
7689: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7690: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7691: and pta.gl_period = p_run_period
7692: -- and pta.pa_period = pp.period_name
7693: -- and pp.gl_period_name = p_run_period
7694: group by

Line 7739: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */

7735: +nvl( pta.i_tot_billable_burdened_cost,0),
7736: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7737: +nvl(pta.i_tot_burdened_cost,0),
7738: 0) * v_pool_percent ) )
7739: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7740: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7741: where /* pars.rule_id = p_rule_id
7742: and pars.run_id = p_run_id
7743: and pars.exclude_flag = 'N'

Line 7740: /* pa_alloc_run_sources pars / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

7736: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7737: +nvl(pta.i_tot_burdened_cost,0),
7738: 0) * v_pool_percent ) )
7739: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7740: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7741: where /* pars.rule_id = p_rule_id
7742: and pars.run_id = p_run_id
7743: and pars.exclude_flag = 'N'
7744: and pta.project_id = pars.project_id

Line 7746: / pta.project_id = l_get_proj.project_id / Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

7742: and pars.run_id = p_run_id
7743: and pars.exclude_flag = 'N'
7744: and pta.project_id = pars.project_id
7745: and pta.task_id = pars.task_id
7746: */ pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7747: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7748: and pta.pa_period = p_run_period
7749: group by
7750: /* Bug 3749469

Line 7747: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */

7743: and pars.exclude_flag = 'N'
7744: and pta.project_id = pars.project_id
7745: and pta.task_id = pars.task_id
7746: */ pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7747: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7748: and pta.pa_period = p_run_period
7749: group by
7750: /* Bug 3749469
7751: pars.rule_id, pars.run_id, pars.line_num,pars.project_id,

Line 7794: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta */

7790: +nvl( pta.i_tot_billable_burdened_cost,0),
7791: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7792: +nvl(pta.i_tot_burdened_cost,0),
7793: 0) * v_pool_percent ) )
7794: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta */
7795: pa_periods pp ,
7796: pa_projects P
7797: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7798: where /* pars.rule_id = p_rule_id

Line 7797: /* pa_alloc_run_sources pars / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

7793: 0) * v_pool_percent ) )
7794: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta */
7795: pa_periods pp ,
7796: pa_projects P
7797: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7798: where /* pars.rule_id = p_rule_id
7799: and pars.run_id = p_run_id
7800: and pars.exclude_flag = 'N'
7801: and pars.project_id = p.project_id

Line 7805: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

7801: and pars.project_id = p.project_id
7802: and pta.project_id = pars.project_id
7803: and pta.task_id = pars.task_id
7804: */
7805: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7806: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7807: and p.project_id = l_get_proj.project_id
7808: and pta.pa_period = pp.period_name
7809: -- Removed check for Project start date bug 1063600

Line 7806: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */

7802: and pta.project_id = pars.project_id
7803: and pta.task_id = pars.task_id
7804: */
7805: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7806: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7807: and p.project_id = l_get_proj.project_id
7808: and pta.pa_period = pp.period_name
7809: -- Removed check for Project start date bug 1063600
7810: -- and pp.end_date >= p.start_date

Line 8304: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */

8300: +nvl(pta.i_tot_labor_hours,0),
8301: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8302: +nvl(pta.i_tot_quantity,0),
8303: 0 )) AMOUNT
8304: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8305: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */
8306: -- pa_periods pp ,
8307: gl_period_statuses gl,
8308: pa_implementations imp

Line 8309: /* pa_alloc_run_targets part / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

8305: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */
8306: -- pa_periods pp ,
8307: gl_period_statuses gl,
8308: pa_implementations imp
8309: /* pa_alloc_run_targets part */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8310: where /* Bug 3749469 part.rule_id = p_rule_id
8311: and part.run_id = p_run_id
8312: and part.exclude_flag = 'N'
8313: and pta.project_id = part.project_id

Line 8317: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

8313: and pta.project_id = part.project_id
8314: and pta.task_id = part.task_id
8315: */ /* added outer join for bug 1900331 */
8316: /* Removed Outer join for bug 2182563 */
8317: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8318: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8319: and pta.gl_period = gl.period_name
8320: and gl.set_of_books_id = imp.set_of_books_id
8321: and gl.application_id = pa_period_process_pkg.application_id

Line 8318: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

8314: and pta.task_id = part.task_id
8315: */ /* added outer join for bug 1900331 */
8316: /* Removed Outer join for bug 2182563 */
8317: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8318: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8319: and pta.gl_period = gl.period_name
8320: and gl.set_of_books_id = imp.set_of_books_id
8321: and gl.application_id = pa_period_process_pkg.application_id
8322: and gl.adjustment_period_flag = 'N'

Line 8370: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */

8366: +nvl(pta.i_tot_labor_hours,0),
8367: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8368: +nvl(pta.i_tot_quantity,0),
8369: 0 )) AMOUNT
8370: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8371: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
8372: -- pa_periods pp
8373: /* pa_alloc_run_targets part */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8374: where /* Bug 3749469

Line 8373: /* pa_alloc_run_targets part / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

8369: 0 )) AMOUNT
8370: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8371: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
8372: -- pa_periods pp
8373: /* pa_alloc_run_targets part */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8374: where /* Bug 3749469
8375: part.rule_id = p_rule_id
8376: and part.run_id = p_run_id
8377: and part.exclude_flag = 'N'

Line 8383: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

8379: and pta.task_id = part.task_id
8380: */
8381: /* added outer join for bug 1900331 */
8382: /* Removed Outer join for bug 2182563 */
8383: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8384: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8385: and pta.gl_period = v_rel_period_name
8386: -- and pta.pa_period = pp.period_name
8387: -- and pp.gl_period_name = v_rel_period_name

Line 8384: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */

8380: */
8381: /* added outer join for bug 1900331 */
8382: /* Removed Outer join for bug 2182563 */
8383: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8384: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8385: and pta.gl_period = v_rel_period_name
8386: -- and pta.pa_period = pp.period_name
8387: -- and pp.gl_period_name = v_rel_period_name
8388: group by /* Bug 3749469

Line 8427: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */

8423: +nvl(pta.i_tot_labor_hours,0),
8424: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8425: +nvl(pta.i_tot_quantity,0),
8426: 0 )) AMOUNT
8427: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8428: /* pa_alloc_run_targets part */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8429: where /* Bug 3749469 part.rule_id = p_rule_id
8430: and part.run_id = p_run_id
8431: and part.exclude_flag = 'N'

Line 8428: /* pa_alloc_run_targets part / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

8424: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8425: +nvl(pta.i_tot_quantity,0),
8426: 0 )) AMOUNT
8427: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8428: /* pa_alloc_run_targets part */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8429: where /* Bug 3749469 part.rule_id = p_rule_id
8430: and part.run_id = p_run_id
8431: and part.exclude_flag = 'N'
8432: and pta.project_id = part.project_id

Line 8436: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

8432: and pta.project_id = part.project_id
8433: and pta.task_id = part.task_id
8434: */ /* added outer join for bug 1900331 */
8435: /* Removed Outer join for bug 2182563 */
8436: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8437: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8438: and pta.pa_period = v_rel_period_name
8439: group by /* Bug 3749469
8440: part.rule_id, part.run_id, part.line_num, part.project_id,

Line 8437: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */

8433: and pta.task_id = part.task_id
8434: */ /* added outer join for bug 1900331 */
8435: /* Removed Outer join for bug 2182563 */
8436: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8437: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8438: and pta.pa_period = v_rel_period_name
8439: group by /* Bug 3749469
8440: part.rule_id, part.run_id, part.line_num, part.project_id,
8441: part.task_id, part.line_percent,

Line 8481: from /* pa_alloc_run_targets part, / / Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

8477: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8478: +nvl(pta.i_tot_quantity,0),
8479: 0 )) AMOUNT
8480: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8481: from /* pa_alloc_run_targets part, */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8482: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8483: pa_periods pp
8484: -- pa_projects_all p ,
8485: where /* Bug 3749469

Line 8482: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */

8478: +nvl(pta.i_tot_quantity,0),
8479: 0 )) AMOUNT
8480: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8481: from /* pa_alloc_run_targets part, */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8482: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8483: pa_periods pp
8484: -- pa_projects_all p ,
8485: where /* Bug 3749469
8486: part.rule_id = p_rule_id

Line 8495: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

8491: and pta.task_id = part.task_id
8492: */
8493: /* added for bug 1900331 */
8494: /* Removed Outer join for bug 2182563 */
8495: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8496: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8497: /* Removed nvl for bug 2751178 */
8498: -- and nvl(pta.pa_period,pp.period_name) = pp.period_name /* bug 2121598 */
8499: and pta.pa_period = pp.period_name

Line 8496: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */

8492: */
8493: /* added for bug 1900331 */
8494: /* Removed Outer join for bug 2182563 */
8495: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8496: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8497: /* Removed nvl for bug 2751178 */
8498: -- and nvl(pta.pa_period,pp.period_name) = pp.period_name /* bug 2121598 */
8499: and pta.pa_period = pp.period_name
8500: -- Removed check for Project start date bug 1063600