APPS.CSM_USER_EVENT_PKG dependencies on JTF_TASK_STATUSES_B

Line 208: jtf_task_statuses_b jts

204: CURSOR l_task_csr (b_user_id number)
205: IS --SELECT tasks which are open and are closed and within history days
206: SELECT jt.task_id
207: FROM JTF_TASKS_B jt,
208: jtf_task_statuses_b jts
209: WHERE jt.created_by = b_user_id
210: AND jts.task_status_id = jt.task_status_id
211: AND ( --task which are closed and within history days
212: ( jt.creation_date BETWEEN SYSDATE AND (SYSDATE - csm_profile_pkg.get_task_history_days(b_user_id))

Line 332: jtf_task_statuses_b jts_jta

328: IS
329: SELECT jtf_ta.task_assignment_id --get all the task assignments which are open and of type TASK
330: FROM jtf_rs_resource_extns jtf_rs,
331: jtf_task_assignments jtf_ta,
332: jtf_task_statuses_b jts_jta
333: WHERE jtf_rs.user_id = p_user_id
334: AND jtf_ta.resource_id = jtf_rs.resource_id
335: AND jts_jta.task_Status_id = jtf_ta.assignment_status_id
336: AND NOT( NVL(jts_jta.cancelled_flag, 'N') = 'Y' OR NVL(jts_jta.closed_flag, 'N') = 'Y'

Line 342: jtf_task_statuses_b jts

338: AND EXISTS (
339:
340: SELECT 1
341: FROM jtf_tasks_b jt,
342: jtf_task_statuses_b jts
343: WHERE jt.task_id = jtf_ta.task_id
344: AND jts.task_status_id = jt.task_status_id
345: AND jt.source_object_type_code ='TASK'
346: AND NOT ( NVL(jts.cancelled_flag, 'N') = 'Y' OR NVL(jts.closed_flag, 'N') = 'Y'