[Home] [Help]
2126:
2127: CURSOR c_type
2128: IS
2129: SELECT budget_year_type_id
2130: FROM psb_budget_periods
2131: WHERE budget_period_id = p_year_id;
2132:
2133: BEGIN
2134:
2707: IS
2708: SELECT start_date,
2709: end_date,
2710: budget_year_type_id
2711: FROM psb_budget_periods
2712: WHERE budget_period_id = p_budget_year_id;
2713:
2714: CURSOR c_stage
2715: IS
2721: IS
2722: SELECT budget_period_id,
2723: start_date,
2724: end_date
2725: FROM psb_budget_periods
2726: WHERE budget_period_type = 'P'
2727: AND parent_budget_period_id = p_budget_year_id
2728: ORDER BY start_date;
2729:
4284: IS
4285: SELECT start_date,
4286: end_date,
4287: budget_year_type_id
4288: FROM psb_budget_periods
4289: WHERE budget_period_id = p_budget_year_id;
4290:
4291: CURSOR c_stage
4292: IS
4298: IS
4299: SELECT budget_period_id,
4300: start_date,
4301: end_date
4302: FROM psb_budget_periods
4303: WHERE budget_period_type = 'P'
4304: AND parent_budget_period_id = p_budget_year_id
4305: ORDER BY start_date;
4306: