APPS.PA_ALLOC_RUN dependencies on GL_PERIODS

Line 4470: from gl_periods glp,

4466: IS
4467: Cursor C_fy_qtr is
4468: select decode(p_run_period_type,'PA', b.pa_period_type, a.accounted_period_type),
4469: a.period_set_name,glp.period_year,glp.quarter_num,glp.period_num,end_date
4470: from gl_periods glp,
4471: gl_sets_of_books a,
4472: pa_implementations b
4473: where a.set_of_books_id = b.set_of_books_id
4474: and glp.period_set_name = a.period_set_name

Line 5356: from gl_periods glp

5352: IS
5353: v_quarter_num NUMBER ;
5354: cursor c_amttype_start_date is
5355: select min (start_date)
5356: from gl_periods glp
5357: where glp.period_set_name = p_period_set_name
5358: and glp.period_type = p_period_type
5359: and glp.end_date <= p_run_period_end_date
5360: and glp.period_year = p_period_year

Line 5364: from gl_periods glp

5360: and glp.period_year = p_period_year
5361: and glp.quarter_num = nvl(v_quarter_num, glp.quarter_num);
5362: cursor c_period_start_date is
5363: select start_date
5364: from gl_periods glp
5365: where glp.period_set_name = p_period_set_name
5366: and glp.period_type = p_period_type
5367: and glp.period_name = p_period ;
5368: BEGIN

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

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

Line 7897: from gl_periods glp

7893: v_rel_period NUMBER ;
7894: v_counter NUMBER ;
7895: Cursor C_rel_period is
7896: select period_name
7897: from gl_periods glp
7898: where glp.period_set_name = p_period_set_name
7899: and glp.period_type = p_period_type
7900: and glp.end_date <= p_run_period_end_date
7901: and glp.adjustment_period_flag <> 'Y' /* Added for Bug#2409474 */

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

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