DBA Data[Home] [Help]

APPS.GMS_SUMMARIZE_BUDGETS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 598: , pa_resource_list_members prl --> Bug 2935048

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

Line 628: , pa_resource_list_members prl --> Bug 2935048

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

Line 656: , pa_resource_list_members prl --> Bug 2935048

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

Line 733: from pa_resource_list_members prl,

729: select 'Y'
730: into v_mixed_level_budget
731: from dual
732: where exists (select '1'
733: from pa_resource_list_members prl,
734: gms_resource_assignments gra,
735: gms_budget_versions gbv
736: where prl.resource_list_id = x_resource_list_id
737: and prl.resource_list_member_id = gra.resource_list_member_id

Line 763: , pa_resource_list_members prl

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

Line 783: , pa_resource_list_members prl

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