APPS.OTA_DELEGATE_BOOKING_API dependencies on FND_USER

Line 1612: l_username fnd_user.user_name%TYPE;

1608: l_course_start_time ota_events.course_start_time%TYPE;
1609: l_event_title ota_events.title%TYPE;
1610: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1611: l_owner_id ota_events.owner_id%TYPE;
1612: l_username fnd_user.user_name%TYPE;
1613: l_auto_waitlist_days NUMBER;
1614: l_auto_waitlist varchar2(1) := 'N';
1615: l_waitlist_size NUMBER := 0;
1616:

Line 1632: FROM fnd_user

1628: FROM dual;
1629:
1630: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS
1631: SELECT user_name
1632: FROM fnd_user
1633: WHERE employee_id = l_owner_id
1634: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);
1635: --bug 603768 changes ends
1636:

Line 2926: l_username fnd_user.user_name%TYPE;

2922: l_owner_id ota_events.owner_id%TYPE;
2923: l_event_id ota_delegate_bookings.event_id%TYPE;
2924: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
2925: l_booking_status ota_booking_status_types.type%TYPE;
2926: l_username fnd_user.user_name%TYPE;
2927: l_auto_waitlist_days NUMBER;
2928: l_auto_waitlist VARCHAR2(2) := 'N';
2929: l_waitlist_size NUMBER := 0;
2930:

Line 2944: FROM fnd_user

2940: FROM dual;
2941:
2942: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS
2943: SELECT user_name
2944: FROM fnd_user
2945: WHERE employee_id = l_owner_id
2946: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);
2947:
2948: CURSOR booking_csr(p_booking_id NUMBER) IS