DBA Data[Home] [Help]

APPS.AMS_SYNC_CALENDAR_PVT dependencies on JTF_RS_GROUP_USAGES

Line 193: FROM JTF_RS_GROUP_USAGES B, JTF_RS_GROUPS_B A

189: IS
190: CURSOR c_get_grp_id IS
191: --BugFix 4256877
192: SELECT B.GROUP_ID RESOURCE_ID
193: FROM JTF_RS_GROUP_USAGES B, JTF_RS_GROUPS_B A
194: WHERE B.USAGE = 'CALENDAR_ITEMS'
195: AND A.GROUP_ID = B.GROUP_ID
196: AND SYSDATE > A.START_DATE_ACTIVE
197: AND (A.END_DATE_ACTIVE IS NULL OR

Line 495: FROM JTF_RS_GROUP_USAGES B, JTF_RS_GROUPS_B A

491: )
492: IS
493: CURSOR c_get_grp_id IS
494: SELECT B.GROUP_ID RESOURCE_ID
495: FROM JTF_RS_GROUP_USAGES B, JTF_RS_GROUPS_B A
496: WHERE B.USAGE = 'CALENDAR_ITEMS'
497: AND A.GROUP_ID = B.GROUP_ID
498: AND SYSDATE > A.START_DATE_ACTIVE
499: AND (A.END_DATE_ACTIVE IS NULL OR