APPS.JTF_CALENDAR_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 2577: From JTF_RS_RESOURCE_EXTNS

2573: Function Get_Res_Timezone_Id ( p_resource_Id IN NUMBER, p_resource_type IN VARCHAR2 ) RETURN Number IS
2574:
2575: Cursor C_Res_TimeZone Is
2576: Select TIME_ZONE
2577: From JTF_RS_RESOURCE_EXTNS
2578: Where RESOURCE_ID = p_resource_id
2579: AND 'RS_'||category = p_resource_type
2580: And trunc(sysdate) between trunc(nvl(START_DATE_ACTIVE,sysdate))
2581: and trunc(nvl(END_DATE_ACTIVE,sysdate));