APPS.GMS_SUMMARIZE_BUDGETS dependencies on PA_BUDGET_ENTRY_METHODS

Line 21: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE ;

17: x_err_code NUMBER(15);
18: x_err_stage VARCHAR2(2000);
19: l_start_date_active DATE ;
20: l_end_date_active DATE ;
21: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE ;
22: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE ;
23: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE ;
24: l_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE ;
25: l_bem_valid VARCHAR2(1);

Line 22: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE ;

18: x_err_stage VARCHAR2(2000);
19: l_start_date_active DATE ;
20: l_end_date_active DATE ;
21: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE ;
22: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE ;
23: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE ;
24: l_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE ;
25: l_bem_valid VARCHAR2(1);
26:

Line 23: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE ;

19: l_start_date_active DATE ;
20: l_end_date_active DATE ;
21: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE ;
22: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE ;
23: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE ;
24: l_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE ;
25: l_bem_valid VARCHAR2(1);
26:
27: begin

Line 24: l_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE ;

20: l_end_date_active DATE ;
21: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE ;
22: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE ;
23: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE ;
24: l_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE ;
25: l_bem_valid VARCHAR2(1);
26:
27: begin
28: p_err_msg_code := 'S' ;

Line 43: from pa_budget_entry_methods

39: l_entry_level_code,
40: l_categorization_code,
41: l_time_phased_type_code,
42: l_burdened_cost_flag
43: from pa_budget_entry_methods
44: where BUDGET_ENTRY_METHOD = p_project_bem ;
45: End if ;
46:
47:

Line 197: from GMS_BUDGET_VERSIONS bv, pa_budget_entry_methods bem

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

Line 425: from gms_budget_versions gbv, pa_budget_entry_methods bem

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

Line 1042: FROM pa_budget_entry_methods pbem,

1038: -- Added the following SELECT and the IF block for Bug:2592747
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'

Line 1122: from pa_budget_entry_methods

1118: If G_project_bem IS NOT NULL then
1119:
1120: select budget_entry_method_code
1121: into x_entry_method_code
1122: from pa_budget_entry_methods
1123: where budget_entry_method = G_project_bem ;
1124: end if ;
1125:
1126: pa_budget_pub.create_draft_budget(p_api_version_number => 1.0