APPS.CSM_TASK_EVENT_PKG dependencies on ASG_BASE

Line 346: (SYSDATE - NVL(csm_profile_pkg.get_task_history_days(asg_base.get_user_id),100))

342: AND jt.task_id = acc.task_id
343: AND jta.task_id = acc.task_id
344: AND jts.task_status_id = jt.task_status_id
345: AND ((CSM_UTIL_PKG.GetLocalTime(jt.scheduled_start_date, acc.user_id) <
346: (SYSDATE - NVL(csm_profile_pkg.get_task_history_days(asg_base.get_user_id),100))
347: )
348: AND
349: (jts.cancelled_flag = 'Y' OR jts.closed_flag = 'Y' OR jts.completed_flag = 'Y' OR jts.rejected_flag = 'Y')
350: );