APPS.CSM_TASK_EVENT_PKG dependencies on CSM_TASK_ASSIGNMENTS_ACC

Line 109: -- check if the task and user pair exist in csm_task_assignments_acc

105: AND jt.created_by = acc.user_id -- task is created by the user
106: AND jt.creation_date
107: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id))
108: ;
109: -- check if the task and user pair exist in csm_task_assignments_acc
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,

Line 113: FROM CSM_TASK_ASSIGNMENTS_ACC acc,

109: -- check if the task and user pair exist in csm_task_assignments_acc
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;