DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on PA_TASKS

Line 111: pa_tasks pt,

107: gb.burdened_cost --gb.raw_cost
108: from
109: gms_budget_lines gb,
110: gms_resource_assignments ga,
111: pa_tasks pt,
112: pa_resource_list_members rm,
113: gms_budget_versions gv
114: where gv.budget_version_id = x_budget_version_id
115: and ga.resource_assignment_id = gb.resource_assignment_id

Line 662: -- pa_tasks task, -- commented for Bug:1703510

658: from pa_expenditure_items_all pe,
659: pa_expenditures_all pa,
660: pa_cost_distribution_lines_all pc,
661: gl_period_STATUSES gl,
662: -- pa_tasks task, -- commented for Bug:1703510
663: gms_award_distributions adl,
664: --pa_periods pp, -- Bug 2887849, EPP changes
665: pa_expenditure_types pet, -- Bug 2069132 (RLMI Change)
666: -- Added the joins with the tables for Bug 5569067

Line 803: --pa_tasks task, -- commented out NOCOPY for porting bug:1703510

799: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
800: from gms_encumbrance_items_all gei,
801: gms_encumbrances_all ge,
802: gl_period_STATUSES gl,
803: --pa_tasks task, -- commented out NOCOPY for porting bug:1703510
804: gms_award_distributions adl,
805: pa_expenditure_types pet -- Bug 2069132 (RLMI Change)
806: -- where task.project_id = x_project_id -- commented out NOCOPY for porting bug:1703510
807: -- and gei.task_id = task.task_id -- commented out NOCOPY for porting bug:1703510