APPS.CSD_SOO_PVT dependencies on JTF_TASK_STATUSES_VL
Line 179: from jtf_task_statuses_vl
175: and nvl(end_date_active, sysdate + 1);
176:
177: CURSOR c_task_status_name(c_task_status_id NUMBER) IS
178: select name 179: from jtf_task_statuses_vl 180: where task_status_id = c_task_status_id and
181: trunc(sysdate) between nvl(start_date_active, sysdate - 1)
182: and nvl(end_date_active, sysdate + 1);
183: