APPS.GMS_SUMMARIZE_BUDGETS dependencies on GMS_RESOURCE_ASSIGNMENTS

Line 295: , gms_resource_assignments gra

291: is
292: select distinct gbl.start_date
293: , gbl.end_date
294: from gms_budget_versions gbv
295: , gms_resource_assignments gra
296: , gms_budget_lines gbl
297: where gbv.budget_version_id = gra.budget_version_id
298: and gra.resource_assignment_id = gbl.resource_assignment_id
299: and gbv.project_id = p_project_id

Line 307: , gms_resource_assignments gra

303: is
304: select distinct gra.resource_list_member_id , gbl.start_date
305: , gbl.end_date
306: from gms_budget_versions gbv
307: , gms_resource_assignments gra
308: , gms_budget_lines gbl
309: where gbv.budget_version_id = gra.budget_version_id
310: and gra.resource_assignment_id = gbl.resource_assignment_id
311: and gbv.project_id = p_project_id

Line 596: , gms_resource_assignments gra

592: , sum(gbl.raw_cost) raw_cost
593: , sum(gbl.burdened_cost) burdened_cost
594: , sum(gbl.quantity) quantity
595: from gms_budget_versions gbv
596: , gms_resource_assignments gra
597: , gms_budget_lines gbl
598: , pa_resource_list_members prl --> Bug 2935048
599: where gbv.project_id = x_project_id
600: and gbv.budget_version_id = gra.budget_version_id

Line 626: , gms_resource_assignments gra

622: , sum(gbl.raw_cost) raw_cost
623: , sum(gbl.burdened_cost) burdened_cost
624: , sum(gbl.quantity) quantity
625: from gms_budget_versions gbv
626: , gms_resource_assignments gra
627: , gms_budget_lines gbl
628: , pa_resource_list_members prl --> Bug 2935048
629: where gbv.project_id = x_project_id
630: and gbv.budget_version_id = gra.budget_version_id

Line 654: , gms_resource_assignments gra

650: , sum(gbl.raw_cost) raw_cost
651: , sum(gbl.burdened_cost) burdened_cost
652: , sum(gbl.quantity) quantity
653: from gms_budget_versions gbv
654: , gms_resource_assignments gra
655: , gms_budget_lines gbl
656: , pa_resource_list_members prl --> Bug 2935048
657: where gbv.project_id = x_project_id
658: and gbv.budget_version_id = gra.budget_version_id

Line 671: from gms_resource_assignments gra,

667: gra.task_id;
668:
669: cursor task_cur is
670: select distinct gra.task_id
671: from gms_resource_assignments gra,
672: gms_budget_versions gbv
673: where gra.project_id = x_project_id
674: and gra.project_id = gbv.project_id
675: and gbv.current_flag = 'Y'

Line 728: gms_resource_assignments gra,

724: into v_mixed_level_budget
725: from dual
726: where exists (select '1'
727: from pa_resource_list_members prl,
728: gms_resource_assignments gra,
729: gms_budget_versions gbv
730: where prl.resource_list_id = x_resource_list_id
731: and prl.resource_list_member_id = gra.resource_list_member_id
732: and gbv.budget_version_id = gra.budget_version_id

Line 755: , gms_resource_assignments gra

751: sum(gbl.raw_cost) raw_cost
752: , sum(gbl.burdened_cost) burdened_cost
753: , sum(gbl.quantity) quantity
754: from gms_budget_versions gbv
755: , gms_resource_assignments gra
756: , gms_budget_lines gbl
757: , pa_resource_list_members prl
758: where gbv.project_id = x_project_id
759: and gbv.budget_version_id = gra.budget_version_id

Line 775: , gms_resource_assignments gra

771: , sum(gbl.raw_cost) raw_cost
772: , sum(gbl.burdened_cost) burdened_cost
773: , sum(gbl.quantity) quantity
774: from gms_budget_versions gbv
775: , gms_resource_assignments gra
776: , gms_budget_lines gbl
777: , pa_resource_list_members prl
778: where gbv.project_id = x_project_id
779: and gbv.budget_version_id = gra.budget_version_id