4: CURSOR Y1 IS
5: SELECT
6: NAME
7: FROM
8: PSB_BUDGET_PERIODS
9: WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID1;
10: CURSOR Y2 IS
11: SELECT
12: NAME
10: CURSOR Y2 IS
11: SELECT
12: NAME
13: FROM
14: PSB_BUDGET_PERIODS
15: WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID2;
16: CURSOR Y3 IS
17: SELECT
18: NAME
16: CURSOR Y3 IS
17: SELECT
18: NAME
19: FROM
20: PSB_BUDGET_PERIODS
21: WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID3;
22: CURSOR Y4 IS
23: SELECT
24: NAME
22: CURSOR Y4 IS
23: SELECT
24: NAME
25: FROM
26: PSB_BUDGET_PERIODS
27: WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID4;
28: L_CALENDAR_ID NUMBER;
29: L_FLEX_MAPPING_SET_ID NUMBER;
30: BEGIN
96: /*SELECT
97: BUDGET_YEAR_TYPE_ID
98: INTO CP_CY_PERIOD_ID
99: FROM
100: PSB_BUDGET_PERIODS
101: WHERE BUDGET_CALENDAR_ID = L_CALENDAR_ID
102: AND BUDGET_PERIOD_TYPE = 'Y';*/
103: END IF;
104: RETURN (TRUE);