DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB dependencies on JTF_RS_GROUPS_B

Line 2585: FROM JTF_RS_GROUPS_B

2581: and trunc(nvl(END_DATE_ACTIVE,sysdate));
2582:
2583: CURSOR c_group_res_timezone Is
2584: SELECT TIME_ZONE
2585: FROM JTF_RS_GROUPS_B
2586: WHERE group_id = p_resource_id
2587: AND trunc(SYSDATE) BETWEEN trunc(nvl(START_DATE_ACTIVE,SYSDATE))
2588: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE));
2589: