[Home] [Help]
2602: CURSOR gl_account_dets IS
2603: SELECT a.set_of_books_id
2604: , b.accounted_period_type
2605: , b.currency_code
2606: FROM pa_implementations a
2607: , gl_sets_of_books b
2608: WHERE a.set_of_books_id = b.set_of_books_id;
2609: CURSOR gl_eligible_amount IS
2610: SELECT nvl(sum( nvl(eligible_amount,0)*DECODE(subtract_flag,'Y',-1,1) ),0)
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
4452: and glp.period_type = decode(p_run_period_type,'PA', b.pa_period_type,
4453: a.accounted_period_type)
5497: /* Using gl_period_statuses instead of pa_periods for Bug 2757875 */
5498: (select /*+ NO_UNNEST */ -- Bug Fix: 3634912 added hint
5499: gl.period_name
5500: from gl_period_statuses gl,
5501: pa_implementations imp
5502: where pta.gl_period = gl.period_name
5503: and gl.set_of_books_id = imp.set_of_books_id
5504: and gl.application_id = pa_period_process_pkg.application_id
5505: and gl.adjustment_period_flag = 'N'
5579: and part.exclude_flag = 'N'
5580: and exists
5581: ( select gl.period_name
5582: from gl_period_statuses gl,
5583: pa_implementations imp
5584: where pta.gl_period = gl.period_name
5585: and gl.set_of_books_id = imp.set_of_books_id
5586: and gl.application_id = pa_period_process_pkg.application_id
5587: and gl.adjustment_period_flag = 'N'
6251: /* Using gl_period_statuses instead of pa_periods for bug 2757875 */
6252: (select /*+ NO_UNNEST */ -- Bug Fix: 3634912 added hint
6253: gl.period_name
6254: From gl_period_statuses gl,
6255: pa_implementations imp
6256: where pta.gl_period = gl.period_name
6257: and gl.set_of_books_id = imp.set_of_books_id
6258: and gl.application_id = pa_period_process_pkg.application_id
6259: and gl.adjustment_period_flag = 'N'
6350: and pars.exclude_flag = 'N'
6351: and Exists
6352: (select gl.period_name
6353: From gl_period_statuses gl,
6354: pa_implementations imp
6355: where pta.gl_period = gl.period_name
6356: and gl.set_of_books_id = imp.set_of_books_id
6357: and gl.application_id = pa_period_process_pkg.application_id
6358: and gl.adjustment_period_flag = 'N'
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 ,
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
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
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'
9289: from pa_alloc_runs
9290: where run_id = p_run_id ;
9291: cursor C_org_id is
9292: select org_id
9293: from pa_implementations ;
9294: run_rec C_run%ROWTYPE ;
9295: v_import_failed VARCHAR2(1) ;
9296: v_org_id NUMBER ;
9297: /* Bug No:- 2487147, UTF8 change : changed v_target_expnd_org to %TYPE */