48: CURSOR C IS SELECT ROWID FROM JTF_CAL_RESOURCE_ASSIGN
49: WHERE CAL_RESOURCE_ASSIGN_ID = X_CAL_RESOURCE_ASSIGN_ID;
50:
51: CURSOR C_RES_NAME IS SELECT RESOURCE_NAME
52: FROM JTF_TASK_RESOURCES_VL
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
369: prime_flag_count NUMBER := 0;
370: l_temp_fnd_end_date date := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');
371:
372: CURSOR C_RES_NAME IS SELECT RESOURCE_NAME
373: FROM JTF_TASK_RESOURCES_VL
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