DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_RS_RESOURCE_EXTNS

Line 3019: From JTF_RS_RESOURCE_EXTNS

3015: Function Get_Res_Timezone_Id ( P_Resource_Id IN Number ) RETURN Number IS
3016:
3017: Cursor C_Res_TimeZone Is
3018: Select TIME_ZONE
3019: From JTF_RS_RESOURCE_EXTNS
3020: Where RESOURCE_ID = p_resource_id
3021: And trunc(sysdate) between trunc(nvl(START_DATE_ACTIVE,sysdate))
3022: and trunc(nvl(END_DATE_ACTIVE,sysdate));
3023: