DBA Data[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: