121: */
122: BEGIN
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'