APPS.CSL_JTF_TASK_ASS_ACC_PKG dependencies on JTF_TASKS_B

Line 45: , JTF_TASKS_B tk

41:
42: CURSOR c_personal_task( b_task_assignment_id NUMBER ) IS
43: SELECT tk.TASK_ID
44: FROM JTF_TASK_ASSIGNMENTS ta
45: , JTF_TASKS_B tk
46: WHERE tk.TASK_ID = ta.TASK_ID
47: AND tk.SOURCE_OBJECT_TYPE_CODE = 'TASK'
48: AND ta.TASK_ASSIGNMENT_ID = b_task_assignment_id;
49:

Line 826: jtf_tasks_b jt,

822: CURSOR lcur_purge_task_assignments is
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