APPS.CSL_JTF_TASK_ASS_ACC_PKG dependencies on JTF_TASK_STATUSES_B

Line 32: FROM JTF_TASK_STATUSES_B

28: r_task_assignment c_task_assignment%ROWTYPE;
29:
30: CURSOR c_assignment_status (b_assignment_status_id NUMBER) IS
31: SELECT null
32: FROM JTF_TASK_STATUSES_B
33: WHERE TASK_STATUS_ID = b_assignment_status_id
34: AND (
35: NVL(ASSIGNED_FLAG, 'N') = 'Y'
36: OR NVL(CANCELLED_FLAG, 'N') = 'Y'

Line 827: jtf_task_statuses_b jts,

823: SELECT acc.task_assignment_id, acc.resource_id
824: FROM csl_jtf_task_ass_acc acc,
825: jtf_task_assignments jta,
826: jtf_tasks_b jt,
827: jtf_task_statuses_b jts,
828: jtf_task_statuses_b jta_jts
829: WHERE acc.task_assignment_id = jta.task_assignment_id
830: AND jt.task_id = jta.task_id
831: AND jts.task_status_id = jt.task_status_id

Line 828: jtf_task_statuses_b jta_jts

824: FROM csl_jtf_task_ass_acc acc,
825: jtf_task_assignments jta,
826: jtf_tasks_b jt,
827: jtf_task_statuses_b jts,
828: jtf_task_statuses_b jta_jts
829: WHERE acc.task_assignment_id = jta.task_assignment_id
830: AND jt.task_id = jta.task_id
831: AND jts.task_status_id = jt.task_status_id
832: AND jta_jts.task_status_id = jta.assignment_status_id