1176: ;
1177:
1178: cursor c_cy_type is
1179: select budget_year_type_id
1180: from psb_budget_year_types_vl
1181: where year_category_type = 'CY';
1182:
1183: cursor c_py_type is
1184: select budget_year_type_id
1181: where year_category_type = 'CY';
1182:
1183: cursor c_py_type is
1184: select budget_year_type_id
1185: from psb_budget_year_types_vl y
1186: where year_category_type = 'PY'
1187: and budget_year_type_id = p_budget_year_type_id
1188: ;
1189: BEGIN
1490:
1491:
1492: cursor c_cy_type is
1493: select budget_year_type_id
1494: from psb_budget_year_types_vl
1495: where year_category_type = 'CY'
1496: ;
1497:
1498: cursor c_py_exists is
1499: select 'Exists'
1500: from dual
1501: where exists
1502: (select 1
1503: from psb_budget_year_types_vl
1504: where budget_year_type_id = p_Budget_Year_Type_ID
1505: and year_category_type = 'PY'
1506: );
1507: -- flag indicating if input budget year id is PY since substitution