APPS.PA_ALLOC_RUN dependencies on GL_PERIODS

Line 4447: from gl_periods glp,

4443: IS
4444: Cursor C_fy_qtr is
4445: select decode(p_run_period_type,'PA', b.pa_period_type, a.accounted_period_type),
4446: a.period_set_name,glp.period_year,glp.quarter_num,glp.period_num,end_date
4447: from gl_periods glp,
4448: gl_sets_of_books a,
4449: pa_implementations b
4450: where a.set_of_books_id = b.set_of_books_id
4451: and glp.period_set_name = a.period_set_name

Line 5333: from gl_periods glp

5329: IS
5330: v_quarter_num NUMBER ;
5331: cursor c_amttype_start_date is
5332: select min (start_date)
5333: from gl_periods glp
5334: where glp.period_set_name = p_period_set_name
5335: and glp.period_type = p_period_type
5336: and glp.end_date <= p_run_period_end_date
5337: and glp.period_year = p_period_year

Line 5341: from gl_periods glp

5337: and glp.period_year = p_period_year
5338: and glp.quarter_num = nvl(v_quarter_num, glp.quarter_num);
5339: cursor c_period_start_date is
5340: select start_date
5341: from gl_periods glp
5342: where glp.period_set_name = p_period_set_name
5343: and glp.period_type = p_period_type
5344: and glp.period_name = p_period ;
5345: BEGIN

Line 7619: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table

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
7623: and pars.run_id = p_run_id

Line 7792: from gl_periods glp

7788: v_rel_period NUMBER ;
7789: v_counter NUMBER ;
7790: Cursor C_rel_period is
7791: select period_name
7792: from gl_periods glp
7793: where glp.period_set_name = p_period_set_name
7794: and glp.period_type = p_period_type
7795: and glp.end_date <= p_run_period_end_date
7796: and glp.adjustment_period_flag <> 'Y' /* Added for Bug#2409474 */

Line 8266: -- Commented out pa_periods. Used the gl_periods column in pa_txn_accum table

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
8270: part.rule_id = p_rule_id