DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on FND_USER

Line 775: SELECT user_name FROM fnd_user WHERE employee_id=p_person_id

771:
772: l_process_display_name varchar2(240);
773:
774: CURSOR csr_get_user_name(p_person_id IN VARCHAR2) IS
775: SELECT user_name FROM fnd_user WHERE employee_id=p_person_id
776: and trunc(sysdate) between trunc(start_date) and trunc(nvl(end_date, sysdate+1));
777:
778:
779: CURSOR csr_get_person_name(p_person_id IN number) IS