APPS.GMS_BUDGET_BALANCE dependencies on PA_IMPLEMENTATIONS

Line 633: gl_sets_of_books glsob and pa_implementations imp for bug# 6043224 */

629: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
630: /* Changed the order of queries and
631: removed join with tables
632: gl_date_period_map map,
633: gl_sets_of_books glsob and pa_implementations imp for bug# 6043224 */
634: FROM GMS_AWARD_DISTRIBUTIONS ADL,
635: PA_COST_DISTRIBUTION_LINES_ALL PC,
636: GL_PERIOD_STATUSES GL,
637: PA_EXPENDITURE_ITEMS_ALL PE,

Line 669: pa_implementations imp

665: pa_expenditure_types pet, -- Bug 2069132 (RLMI Change)
666: -- Added the joins with the tables for Bug 5569067
667: gl_date_period_map map,
668: gl_sets_of_books glsob,
669: pa_implementations imp
670: where adl.project_id = x_project_id -- Bug 2387678
671: -- where pc.project_id = x_project_id -- added for porting Bug:1703510
672: --where task.project_id = x_project_id -- commented for above bug
673: --and pe.task_id = task.task_id -- commented for above bug

Line 1944: from pa_implementations;

1940:
1941: x_e_stage := '100';
1942: -- TO SELECT SET OF BOOKS ID
1943: select set_of_books_id into x_sob_id
1944: from pa_implementations;
1945: x_e_stage := '200';
1946: IF L_DEBUG = 'Y' THEN
1947: gms_error_pkg.gms_debug('gms_budget_balance -1','C');
1948: END IF;