53: WHERE RESOURCE_ID = X_RESOURCE_ID
54: AND RESOURCE_TYPE = X_RESOURCE_TYPE_CODE;
55:
56: CURSOR C_CAL_NAME(p_calendar_id NUMBER) IS SELECT CALENDAR_NAME
57: FROM JTF_CALENDARS_TL
58: WHERE CALENDAR_ID = p_calendar_id
59: AND LANGUAGE=USERENV('LANG');
60:
61: CURSOR C_CAL_ID(p_primary_calendar_flag VARCHAR2) IS SELECT CALENDAR_ID
374: WHERE RESOURCE_ID = X_RESOURCE_ID
375: AND RESOURCE_TYPE = X_RESOURCE_TYPE_CODE;
376:
377: CURSOR C_CAL_NAME(p_calendar_id NUMBER) IS SELECT CALENDAR_NAME
378: FROM JTF_CALENDARS_TL
379: WHERE CALENDAR_ID = p_calendar_id
380: AND LANGUAGE=USERENV('LANG');
381:
382: CURSOR C_CAL_ID(p_primary_calendar_flag VARCHAR2) IS SELECT CALENDAR_ID