DBA Data[Home] [Help]

APPS.CSM_TASK_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 114: JTF_TASK_ASSIGNMENTS jta

110: CURSOR l_task_assignment_csr (b_task_id NUMBER, b_user_id NUMBER)
111: IS
112: SELECT acc.counter
113: FROM CSM_TASK_ASSIGNMENTS_ACC acc,
114: JTF_TASK_ASSIGNMENTS jta
115: WHERE acc.TASK_ASSIGNMENT_ID = jta.TASK_ASSIGNMENT_ID
116: AND jta.TASK_ID = b_task_id
117: AND acc.USER_ID = b_user_id;
118:

Line 340: jtf_task_assignments jta

336: SELECT acc.user_id, jta.task_assignment_id
337: FROM jtf_tasks_b jt,
338: csm_tasks_acc acc,
339: jtf_task_statuses_b jts,
340: jtf_task_assignments jta
341: WHERE acc.task_id = p_task_id
342: AND jt.task_id = acc.task_id
343: AND jta.task_id = acc.task_id
344: AND jts.task_status_id = jt.task_status_id