APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_RS_RESOURCE_EXTNS
Line 3089: From JTF_RS_RESOURCE_EXTNS
3085: Function Get_Res_Timezone_Id ( p_resource_Id IN NUMBER, p_resource_type IN VARCHAR2 ) RETURN Number IS
3086:
3087: Cursor C_Res_TimeZone Is
3088: Select TIME_ZONE 3089: From JTF_RS_RESOURCE_EXTNS 3090: Where RESOURCE_ID = p_resource_id
3091: AND 'RS_'||category = p_resource_type
3092: And trunc(sysdate) between trunc(nvl(START_DATE_ACTIVE,sysdate))
3093: and trunc(nvl(END_DATE_ACTIVE,sysdate));