DBA Data[Home] [Help]

APPS.AMS_SYNC_CALENDAR_PVT dependencies on JTF_RS_GROUPS_B

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

Line 500: A.END_DATE_ACTIVE >= SYSDATE); -- BugFix 4256877 jtf_rs_groups_vl to jtf_rs_groups_b

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
500: A.END_DATE_ACTIVE >= SYSDATE); -- BugFix 4256877 jtf_rs_groups_vl to jtf_rs_groups_b
501: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
502:
503: --BugFix 4256877 AMS_CAMPAIGNS_V to AMS_CAMPAIGNS_ALL_B
504: