[Home] [Help]
113:
114: select count(distinct budget_entry_method_code) ,
115: count(distinct resource_list_id ), count(distinct award_id)
116: into l_bem_count, l_res_list_count, l_award_count
117: from GMS_BUDGET_VERSIONS
118: where budget_status_code = 'B'
119: and current_flag = 'Y'
120: and project_id = x_project_id ;
121: IF L_DEBUG = 'Y' THEN
163: If l_bem_count >= 1 and l_res_list_count = 1 then
164:
165: select distinct rl.name
166: into l_res_list_name
167: from GMS_BUDGET_VERSIONS gb , pa_resource_lists rl
168: where gb.resource_list_id = rl.resource_list_id
169: and budget_status_code = 'B'
170: and current_flag = 'Y'
171: and project_id = x_project_id ;
193:
194: IF l_bem_count = 1 and l_res_list_count = 1 and l_award_count > 1 THEN
195: select distinct time_phased_type_code -- Added distinct for bug : 5750106
196: into l_time_phased_type_code
197: from GMS_BUDGET_VERSIONS bv, pa_budget_entry_methods bem
198: where bv.budget_entry_method_code = bem.budget_entry_method_code
199: and bv.project_id = x_project_id ;
200:
201: IF l_time_phased_type_code = 'R' and l_res_list_name = 'None' then
260:
261: IF l_res_categorized = 'Y' THEN
262: select distinct resource_list_id
263: into G_pa_res_list_id
264: from GMS_BUDGET_VERSIONS
265: where budget_status_code = 'B'
266: and current_flag = 'Y'
267: and project_id = x_project_id ;
268: IF L_DEBUG = 'Y' THEN
290: cursor get_curr_date_range_csr (p_project_id in NUMBER, p_resource_list_member_id IN NUMBER )
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
302: cursor get_other_date_range_csr ( p_project_id in NUMBER)
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
320: END IF;
321:
322: select count(award_id)
323: into l_award_count
324: from GMS_BUDGET_VERSIONS
325: where budget_status_code = 'B'
326: and current_flag = 'Y'
327: and project_id = x_project_id;
328:
421: select distinct gbv.resource_list_id -- Added distinct for Bug:2254944
422: , gbv.budget_entry_method_code , bem.time_phased_type_code -- Added time_phase_type_code for bug: 5750106
423: into x_resource_list_id
424: , x_budget_entry_method_code,l_time_phased_type_code
425: from gms_budget_versions gbv, pa_budget_entry_methods bem
426: where gbv.project_id = x_project_id
427: and gbv.budget_entry_method_code = bem.budget_entry_method_code -- Added for bug 5750106
428: and gbv.current_flag = 'Y';
429: -- and rownum < 2; -- Commented out NOCOPY for Bug:2254944
591: , gra.task_id
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
621: , gra.task_id
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
649: , gra.task_id
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
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'
676: and gbv.budget_status_code = 'B';
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
733: and gbv.current_flag = 'Y'
750: gbv.project_id ,
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
770: gbv.project_id
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
1039:
1040: SELECT distinct entry_level_code -- Added DISTINCT for Bug:2907692
1041: INTO x_entry_level_code
1042: FROM pa_budget_entry_methods pbem,
1043: gms_budget_versions gbv
1044: WHERE gbv.budget_entry_method_code = pbem.budget_entry_method_code
1045: AND gbv.project_id = x_project_id
1046: AND gbv.budget_status_code = 'B'
1047: AND gbv.current_flag = 'Y';