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.

[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_TXN_ACCUM_V

Line 7548: from pa_alloc_txn_accum_v pta,

7544: +nvl( pta.i_tot_billable_burdened_cost,0),
7545: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7546: +nvl(pta.i_tot_burdened_cost,0),
7547: 0) * v_pool_percent ) )
7548: from pa_alloc_txn_accum_v pta,
7549: /* FP.M : Allocation Impact : pa_txn_accum pta */
7550: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */
7551: -- pa_periods pp ,
7552: gl_period_statuses gl ,

Line 7554: /* 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 */

7550: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */
7551: -- pa_periods pp ,
7552: gl_period_statuses gl ,
7553: pa_implementations imp
7554: /* 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 */
7555: where /* Bug 3749469
7556: pars.rule_id = p_rule_id
7557: and pars.run_id = p_run_id
7558: and pars.exclude_flag = 'N'

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

7558: and pars.exclude_flag = 'N'
7559: and pta.project_id = pars.project_id
7560: and pta.task_id = pars.task_id
7561: */
7562: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7563: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7564: and pta.gl_period = gl.period_name
7565: and gl.set_of_books_id = imp.set_of_books_id
7566: and gl.application_id = pa_period_process_pkg.application_id

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

7559: and pta.project_id = pars.project_id
7560: and pta.task_id = pars.task_id
7561: */
7562: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7563: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7564: and pta.gl_period = gl.period_name
7565: and gl.set_of_books_id = imp.set_of_books_id
7566: and gl.application_id = pa_period_process_pkg.application_id
7567: and gl.adjustment_period_flag = 'N'

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

7614: +nvl( pta.i_tot_billable_burdened_cost,0),
7615: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7616: +nvl(pta.i_tot_burdened_cost,0),
7617: 0) * v_pool_percent ) )
7618: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7619: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
7620: -- pa_periods pp
7621: /* 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 */
7622: where /* pars.rule_id = p_rule_id

Line 7621: /* 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 */

7617: 0) * v_pool_percent ) )
7618: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7619: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
7620: -- pa_periods pp
7621: /* 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 */
7622: where /* pars.rule_id = p_rule_id
7623: and pars.run_id = p_run_id
7624: and pars.exclude_flag = 'N'
7625: and pta.project_id = pars.project_id

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

7624: and pars.exclude_flag = 'N'
7625: and pta.project_id = pars.project_id
7626: and pta.task_id = pars.task_id
7627: */
7628: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7629: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7630: and pta.gl_period = p_run_period
7631: -- and pta.pa_period = pp.period_name
7632: -- and pp.gl_period_name = p_run_period

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

7625: and pta.project_id = pars.project_id
7626: and pta.task_id = pars.task_id
7627: */
7628: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7629: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7630: and pta.gl_period = p_run_period
7631: -- and pta.pa_period = pp.period_name
7632: -- and pp.gl_period_name = p_run_period
7633: group by

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

7674: +nvl( pta.i_tot_billable_burdened_cost,0),
7675: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7676: +nvl(pta.i_tot_burdened_cost,0),
7677: 0) * v_pool_percent ) )
7678: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7679: /* 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 */
7680: where /* pars.rule_id = p_rule_id
7681: and pars.run_id = p_run_id
7682: and pars.exclude_flag = 'N'

Line 7679: /* 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 */

7675: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7676: +nvl(pta.i_tot_burdened_cost,0),
7677: 0) * v_pool_percent ) )
7678: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta */
7679: /* 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 */
7680: where /* pars.rule_id = p_rule_id
7681: and pars.run_id = p_run_id
7682: and pars.exclude_flag = 'N'
7683: and pta.project_id = pars.project_id

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

7681: and pars.run_id = p_run_id
7682: and pars.exclude_flag = 'N'
7683: and pta.project_id = pars.project_id
7684: and pta.task_id = pars.task_id
7685: */ pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7686: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7687: and pta.pa_period = p_run_period
7688: group by
7689: /* Bug 3749469

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

7682: and pars.exclude_flag = 'N'
7683: and pta.project_id = pars.project_id
7684: and pta.task_id = pars.task_id
7685: */ pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7686: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7687: and pta.pa_period = p_run_period
7688: group by
7689: /* Bug 3749469
7690: pars.rule_id, pars.run_id, pars.line_num,pars.project_id,

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

7729: +nvl( pta.i_tot_billable_burdened_cost,0),
7730: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7731: +nvl(pta.i_tot_burdened_cost,0),
7732: 0) * v_pool_percent ) )
7733: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta */
7734: pa_periods pp ,
7735: pa_projects P
7736: /* 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 */
7737: where /* pars.rule_id = p_rule_id

Line 7736: /* 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 */

7732: 0) * v_pool_percent ) )
7733: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta */
7734: pa_periods pp ,
7735: pa_projects P
7736: /* 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 */
7737: where /* pars.rule_id = p_rule_id
7738: and pars.run_id = p_run_id
7739: and pars.exclude_flag = 'N'
7740: and pars.project_id = p.project_id

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

7740: and pars.project_id = p.project_id
7741: and pta.project_id = pars.project_id
7742: and pta.task_id = pars.task_id
7743: */
7744: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7745: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7746: and p.project_id = l_get_proj.project_id
7747: and pta.pa_period = pp.period_name
7748: -- Removed check for Project start date bug 1063600

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

7741: and pta.project_id = pars.project_id
7742: and pta.task_id = pars.task_id
7743: */
7744: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7745: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
7746: and p.project_id = l_get_proj.project_id
7747: and pta.pa_period = pp.period_name
7748: -- Removed check for Project start date bug 1063600
7749: -- and pp.end_date >= p.start_date

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

8195: +nvl(pta.i_tot_labor_hours,0),
8196: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8197: +nvl(pta.i_tot_quantity,0),
8198: 0 )) AMOUNT
8199: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8200: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */
8201: -- pa_periods pp ,
8202: gl_period_statuses gl,
8203: pa_implementations imp

Line 8204: /* 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 */

8200: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */
8201: -- pa_periods pp ,
8202: gl_period_statuses gl,
8203: pa_implementations imp
8204: /* 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 */
8205: where /* Bug 3749469 part.rule_id = p_rule_id
8206: and part.run_id = p_run_id
8207: and part.exclude_flag = 'N'
8208: and pta.project_id = part.project_id

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

8208: and pta.project_id = part.project_id
8209: and pta.task_id = part.task_id
8210: */ /* added outer join for bug 1900331 */
8211: /* Removed Outer join for bug 2182563 */
8212: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8213: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8214: and pta.gl_period = gl.period_name
8215: and gl.set_of_books_id = imp.set_of_books_id
8216: and gl.application_id = pa_period_process_pkg.application_id

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

8209: and pta.task_id = part.task_id
8210: */ /* added outer join for bug 1900331 */
8211: /* Removed Outer join for bug 2182563 */
8212: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8213: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8214: and pta.gl_period = gl.period_name
8215: and gl.set_of_books_id = imp.set_of_books_id
8216: and gl.application_id = pa_period_process_pkg.application_id
8217: and gl.adjustment_period_flag = 'N'

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

8261: +nvl(pta.i_tot_labor_hours,0),
8262: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8263: +nvl(pta.i_tot_quantity,0),
8264: 0 )) AMOUNT
8265: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8266: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
8267: -- pa_periods pp
8268: /* 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 */
8269: where /* Bug 3749469

Line 8268: /* 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 */

8264: 0 )) AMOUNT
8265: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8266: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table
8267: -- pa_periods pp
8268: /* 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 */
8269: where /* Bug 3749469
8270: part.rule_id = p_rule_id
8271: and part.run_id = p_run_id
8272: and part.exclude_flag = 'N'

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

8274: and pta.task_id = part.task_id
8275: */
8276: /* added outer join for bug 1900331 */
8277: /* Removed Outer join for bug 2182563 */
8278: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8279: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8280: and pta.gl_period = v_rel_period_name
8281: -- and pta.pa_period = pp.period_name
8282: -- and pp.gl_period_name = v_rel_period_name

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

8275: */
8276: /* added outer join for bug 1900331 */
8277: /* Removed Outer join for bug 2182563 */
8278: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8279: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8280: and pta.gl_period = v_rel_period_name
8281: -- and pta.pa_period = pp.period_name
8282: -- and pp.gl_period_name = v_rel_period_name
8283: group by /* Bug 3749469

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

8318: +nvl(pta.i_tot_labor_hours,0),
8319: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8320: +nvl(pta.i_tot_quantity,0),
8321: 0 )) AMOUNT
8322: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8323: /* 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 */
8324: where /* Bug 3749469 part.rule_id = p_rule_id
8325: and part.run_id = p_run_id
8326: and part.exclude_flag = 'N'

Line 8323: /* 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 */

8319: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8320: +nvl(pta.i_tot_quantity,0),
8321: 0 )) AMOUNT
8322: from pa_alloc_txn_accum_v pta /* FP.M : Allocation Impact : pa_txn_accum pta, */
8323: /* 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 */
8324: where /* Bug 3749469 part.rule_id = p_rule_id
8325: and part.run_id = p_run_id
8326: and part.exclude_flag = 'N'
8327: and pta.project_id = part.project_id

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

8327: and pta.project_id = part.project_id
8328: and pta.task_id = part.task_id
8329: */ /* added outer join for bug 1900331 */
8330: /* Removed Outer join for bug 2182563 */
8331: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8332: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8333: and pta.pa_period = v_rel_period_name
8334: group by /* Bug 3749469
8335: part.rule_id, part.run_id, part.line_num, part.project_id,

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

8328: and pta.task_id = part.task_id
8329: */ /* added outer join for bug 1900331 */
8330: /* Removed Outer join for bug 2182563 */
8331: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8332: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Task_Id */
8333: and pta.pa_period = v_rel_period_name
8334: group by /* Bug 3749469
8335: part.rule_id, part.run_id, part.line_num, part.project_id,
8336: part.task_id, part.line_percent,

Line 8376: 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 */

8372: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8373: +nvl(pta.i_tot_quantity,0),
8374: 0 )) AMOUNT
8375: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8376: 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 */
8377: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8378: pa_periods pp
8379: -- pa_projects_all p ,
8380: where /* Bug 3749469

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

8373: +nvl(pta.i_tot_quantity,0),
8374: 0 )) AMOUNT
8375: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8376: 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 */
8377: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8378: pa_periods pp
8379: -- pa_projects_all p ,
8380: where /* Bug 3749469
8381: part.rule_id = p_rule_id

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

8386: and pta.task_id = part.task_id
8387: */
8388: /* added for bug 1900331 */
8389: /* Removed Outer join for bug 2182563 */
8390: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8391: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8392: /* Removed nvl for bug 2751178 */
8393: -- and nvl(pta.pa_period,pp.period_name) = pp.period_name /* bug 2121598 */
8394: and pta.pa_period = pp.period_name

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

8387: */
8388: /* added for bug 1900331 */
8389: /* Removed Outer join for bug 2182563 */
8390: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8391: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8392: /* Removed nvl for bug 2751178 */
8393: -- and nvl(pta.pa_period,pp.period_name) = pp.period_name /* bug 2121598 */
8394: and pta.pa_period = pp.period_name
8395: -- Removed check for Project start date bug 1063600