APPS.CUG_GENERIC_WF_PKG dependencies on JTF_TASK_STATUSES_VL

Line 1369: SELECT tsk.task_number, tsk.task_id, tsk.task_type_id, sts.name FROM JTF_TASKS_VL tsk, JTF_TASK_STATUSES_VL sts WHERE

1365:
1366: l_API_ERROR EXCEPTION;
1367:
1368: CURSOR c_SRTasks_csr IS
1369: SELECT tsk.task_number, tsk.task_id, tsk.task_type_id, sts.name FROM JTF_TASKS_VL tsk, JTF_TASK_STATUSES_VL sts WHERE
1370: tsk.task_status_id = sts.task_status_id and
1371: tsk.SOURCE_OBJECT_ID = l_request_id and
1372: tsk.source_object_type_code = 'SR';
1373: l_SRTasks_rec c_SRTasks_csr%ROWTYPE;