DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on GL_PERIOD_STATUSES

Line 5497: /* Using gl_period_statuses instead of pa_periods for Bug 2757875 */

5493: and parr.member_type = 'B'
5494: and part.project_id = c_projects_rec.project_id
5495: and part.exclude_flag = 'N'
5496: and exists
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

Line 5500: from gl_period_statuses gl,

5496: and exists
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

Line 5582: from gl_period_statuses gl,

5578: and part.project_id = c_projects_rec.project_id
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

Line 6251: /* Using gl_period_statuses instead of pa_periods for bug 2757875 */

6247: and parr.member_type = 'S'
6248: and pars.project_id = c_projects_rec.project_id
6249: and pars.exclude_flag = 'N'
6250: and exists
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

Line 6254: From gl_period_statuses gl,

6250: and exists
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

Line 6353: From gl_period_statuses gl,

6349: and pars.project_id = C_projects_rec.project_id
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

Line 7550: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */

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 ,
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 */

Line 7552: gl_period_statuses gl ,

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 ,
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

Line 8200: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */

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
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 */

Line 8202: gl_period_statuses gl,

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
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