DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on FND_USER

Line 2064: SELECT user_name FROM fnd_user WHERE employee_id=p_person_id

2060:
2061: l_process_display_name varchar2(240);
2062:
2063: CURSOR csr_get_user_name(p_person_id IN VARCHAR2) IS
2064: SELECT user_name FROM fnd_user WHERE employee_id=p_person_id
2065: and trunc(sysdate) between trunc(start_date) and trunc(nvl(end_date, sysdate+1));
2066:
2067:
2068: CURSOR csr_get_person_name(p_person_id IN number) IS