DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_RS_GROUPS_B

Line 3097: FROM JTF_RS_GROUPS_B

3093: and trunc(nvl(END_DATE_ACTIVE,sysdate));
3094:
3095: CURSOR c_group_res_timezone Is
3096: SELECT TIME_ZONE
3097: FROM JTF_RS_GROUPS_B
3098: WHERE group_id = p_resource_id
3099: AND trunc(SYSDATE) BETWEEN trunc(nvl(START_DATE_ACTIVE,SYSDATE))
3100: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE));
3101: