APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 45: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))

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)))
46: AND jts.task_status_id = jt.task_status_id
47: AND jts_jta.task_status_id = jta.assignment_status_id
48: AND (jts.cancelled_flag = 'Y' OR jts.closed_flag = 'Y'
49: OR jts.completed_flag = 'Y' OR jts.rejected_flag = 'Y'

Line 603: l_organization_id := csm_profile_pkg.get_organization_id(l_taskassgdetails_rec.user_id);

599: RETURN;
600: END IF;
601:
602: -- get Service Inv Validation org
603: l_organization_id := csm_profile_pkg.get_organization_id(l_taskassgdetails_rec.user_id);
604:
605: --get task notes moved to task_assignments_acc processor
606:
607:

Line 1067: l_organization_id := csm_profile_pkg.get_organization_id(l_task_assg_purge_rec.user_id);

1063: RETURN;
1064: END IF;
1065: CLOSE l_task_assg_purge_csr;
1066: -- get Service Inv Validation org
1067: l_organization_id := csm_profile_pkg.get_organization_id(l_task_assg_purge_rec.user_id);
1068:
1069: l_htm5_user:=csm_util_pkg.is_html5_user(l_task_assg_purge_rec.user_id);
1070:
1071: --html5 functionality