3019:
3020: FUNCTION Get_Calendar_Name (
3021: p_Calendar_Id IN NUMBER
3022: ) RETURN VARCHAR2 IS
3023: l_Calendar_Name BSC_SYS_CALENDARS_VL.NAME%TYPE;
3024: BEGIN
3025:
3026: SELECT C.NAME INTO l_Calendar_Name
3027: FROM BSC_SYS_CALENDARS_VL C
3023: l_Calendar_Name BSC_SYS_CALENDARS_VL.NAME%TYPE;
3024: BEGIN
3025:
3026: SELECT C.NAME INTO l_Calendar_Name
3027: FROM BSC_SYS_CALENDARS_VL C
3028: WHERE C.CALENDAR_ID = p_Calendar_Id;
3029:
3030: RETURN l_Calendar_Name;
3031: