DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on JTF_TASK_STATUSES_B

Line 40: jtf_task_statuses_b jts,

36: jt.source_object_type_code
37: FROM csm_task_assignments_acc acc,
38: jtf_task_assignments jta,
39: jtf_tasks_b jt,
40: jtf_task_statuses_b jts,
41: jtf_task_statuses_b jts_jta
42: WHERE acc.task_assignment_id = jta.task_assignment_id
43: AND jt.task_id = jta.task_id
44: AND (jt.scheduled_start_date

Line 41: jtf_task_statuses_b jts_jta

37: FROM csm_task_assignments_acc acc,
38: jtf_task_assignments jta,
39: jtf_tasks_b jt,
40: jtf_task_statuses_b jts,
41: jtf_task_statuses_b jts_jta
42: WHERE acc.task_assignment_id = jta.task_assignment_id
43: AND jt.task_id = jta.task_id
44: AND (jt.scheduled_start_date
45: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))