DBA Data[Home] [Help]

APPS.AMS_SYNC_CALENDAR_PVT dependencies on JTF_NUMBER_TABLE

Line 200: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

196: AND SYSDATE > A.START_DATE_ACTIVE
197: AND (A.END_DATE_ACTIVE IS NULL OR
198: A.END_DATE_ACTIVE >= SYSDATE);
199:
200: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
201:
202: CURSOR c_get_cre_csch_items (x_criteria_rec cal_criteria_rec) IS
203: SELECT obj.SCHEDULE_Id
204: , obj.START_DATE_TIME

Line 501: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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:
505: CURSOR c_get_upd_csch_items (x_criteria_rec cal_criteria_rec) IS