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 727: from pa_resource_list_members prl,

723: select 'Y'
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

Line 757: , pa_resource_list_members prl

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
760: and gra.resource_assignment_id = gbl.resource_assignment_id
761: and gbv.current_flag = 'Y'

Line 777: , pa_resource_list_members prl

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
780: and gra.resource_assignment_id = gbl.resource_assignment_id
781: and gbv.current_flag = 'Y'