APPS.GMS_SUMMARIZE_BUDGETS dependencies on GMS_BUDGET_LINES

Line 296: , gms_budget_lines gbl

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
300: and gra.resource_list_member_id = p_resource_list_member_id;

Line 308: , gms_budget_lines gbl

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
312: and gbv.current_flag = 'Y'

Line 597: , gms_budget_lines gbl

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
601: and gra.resource_assignment_id = gbl.resource_assignment_id

Line 627: , gms_budget_lines gbl

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
631: and gra.resource_assignment_id = gbl.resource_assignment_id

Line 655: , gms_budget_lines gbl

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
659: and gra.resource_assignment_id = gbl.resource_assignment_id

Line 762: , gms_budget_lines gbl

758: , sum(gbl.burdened_cost) burdened_cost
759: , sum(gbl.quantity) quantity
760: from gms_budget_versions gbv
761: , gms_resource_assignments gra
762: , gms_budget_lines gbl
763: , pa_resource_list_members prl
764: where gbv.project_id = x_project_id
765: and gbv.budget_version_id = gra.budget_version_id
766: and gra.resource_assignment_id = gbl.resource_assignment_id

Line 782: , gms_budget_lines gbl

778: , sum(gbl.burdened_cost) burdened_cost
779: , sum(gbl.quantity) quantity
780: from gms_budget_versions gbv
781: , gms_resource_assignments gra
782: , gms_budget_lines gbl
783: , pa_resource_list_members prl
784: where gbv.project_id = x_project_id
785: and gbv.budget_version_id = gra.budget_version_id
786: and gra.resource_assignment_id = gbl.resource_assignment_id

Line 799: , gms_budget_lines gbl

795: select distinct gra.resource_list_member_id , gbl.start_date
796: , gbl.end_date
797: from gms_budget_versions gbv
798: , gms_resource_assignments gra
799: , gms_budget_lines gbl
800: where gbv.budget_version_id = gra.budget_version_id
801: and gra.resource_assignment_id = gbl.resource_assignment_id
802: and gbv.project_id = p_project_id
803: and gbv.current_flag = 'Y'

Line 813: , gms_budget_lines gbl

809: select distinct gbl.start_date
810: , gbl.end_date
811: from gms_budget_versions gbv
812: , gms_resource_assignments gra
813: , gms_budget_lines gbl
814: where gbv.budget_version_id = gra.budget_version_id
815: and gra.resource_assignment_id = gbl.resource_assignment_id
816: and gbv.project_id = p_project_id
817: and gra.resource_list_member_id = p_resource_list_member_id;