APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 55: l_approved_cost_plan_type_flag Pa_Proj_Fp_Options.APPROVED_COST_PLAN_TYPE_FLAG%TYPE; -- Added for bug 4907408

51: l_est_qty pa_budget_versions.est_quantity%TYPE;
52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%TYPE;
53: l_est_proj_revenue pa_budget_versions.est_project_revenue%TYPE;
54:
55: l_approved_cost_plan_type_flag Pa_Proj_Fp_Options.APPROVED_COST_PLAN_TYPE_FLAG%TYPE; -- Added for bug 4907408
56:
57: CURSOR est_amt_csr
58: IS
59: SELECT est_project_raw_cost,

Line 98: SELECT COUNT(*) INTO l_no_of_app_plan_types FROM Pa_Proj_Fp_Options

94: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
95: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
96: END IF;
97:
98: SELECT COUNT(*) INTO l_no_of_app_plan_types FROM Pa_Proj_Fp_Options
99: WHERE
100: Project_Id = p_project_id AND
101: Fin_Plan_Option_Level_Code = 'PLAN_TYPE' AND
102: ( NVL(Approved_Cost_Plan_Type_Flag ,'N') = 'Y' OR

Line 114: * FROM pa_proj_fp_options

110: *
111: *IF l_no_of_app_plan_types = 1 THEN
112: * SELECT approved_cost_plan_type_flag
113: * INTO l_approved_cost_plan_type_flag
114: * FROM pa_proj_fp_options
115: * WHERE project_id = p_project_id
116: * AND fin_plan_option_level_code = 'PLAN_TYPE'
117: * AND ( NVL(approved_cost_plan_type_flag,'N') = 'Y'
118: * OR

Line 127: FROM pa_proj_fp_options

123: SELECT 'Y'
124: INTO l_approved_cost_plan_type_flag
125: FROM DUAL
126: WHERE EXISTS (SELECT 'X'
127: FROM pa_proj_fp_options
128: WHERE project_id = p_project_id
129: AND fin_plan_option_level_code = 'PLAN_TYPE'
130: AND approved_cost_plan_type_flag = 'Y');
131: EXCEPTION