[Home] [Help]
APPS.JTF_TASK_TEMPLATES_UTL dependencies on JTF_TASK_TEMP_GROUPS_B
Line 12: FROM jtf_task_temp_groups_b
8: -- Bug 3374694: modified cursor query for truncating time portion of dates.
9: CURSOR c_task_template_group_id
10: IS
11: SELECT task_template_group_id
12: FROM jtf_task_temp_groups_b
13: WHERE task_template_group_id = p_task_template_group_id
14: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
15: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE);
16: