APPS.OTA_BULK_ENROLL_UTIL dependencies on FND_USER

Line 467: FND_USER

463: CURSOR csr_user(p_owner_id in number) IS
464: SELECT
465: USER_NAME
466: FROM
467: FND_USER
468: WHERE
469: Employee_id = p_owner_id ;
470:
471: CURSOR csr_activity(p_activity_version_id number )

Line 601: l_owner_username fnd_user.user_name%type;

597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;
600: l_version_name ota_activity_versions.version_name%type;
601: l_owner_username fnd_user.user_name%type;
602: l_offering_id ota_events.offering_id%type;
603: l_booking_status_used VARCHAR2(20);
604:
605: l_existing_bookings NUMBER;

Line 1238: FROM fnd_user

1234:
1235:
1236: CURSOR csr_get_user_name(p_person_id IN VARCHAR2) IS
1237: SELECT user_name
1238: FROM fnd_user
1239: WHERE employee_id=p_person_id;
1240:
1241:
1242: CURSOR csr_get_person_name(p_person_id IN number) IS

Line 1332: FROM fnd_user

1328: FETCH csr_get_person_name INTO l_person_full_name;
1329: CLOSE csr_get_person_name;
1330:
1331: SELECT user_name INTO l_user_name
1332: FROM fnd_user
1333: WHERE employee_id=l_person_id
1334: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')) --Bug 5676892
1335: AND ROWNUM =1 ;
1336: fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);