APPS.OTA_DELEGATE_BOOKING_API dependencies on FND_USER

Line 1782: l_username fnd_user.user_name%TYPE;

1778: l_course_start_time ota_events.course_start_time%TYPE;
1779: l_event_title ota_events.title%TYPE;
1780: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1781: l_owner_id ota_events.owner_id%TYPE;
1782: l_username fnd_user.user_name%TYPE;
1783: l_auto_waitlist_days NUMBER;
1784: l_auto_waitlist varchar2(1) := 'N';
1785: l_waitlist_size NUMBER := 0;
1786:

Line 1802: FROM fnd_user

1798: FROM dual;
1799:
1800: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS
1801: SELECT user_name
1802: FROM fnd_user
1803: WHERE employee_id = l_owner_id
1804: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);
1805: --bug 603768 changes ends
1806:

Line 3159: l_username fnd_user.user_name%TYPE;

3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;
3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3158: l_booking_status ota_booking_status_types.type%TYPE;
3159: l_username fnd_user.user_name%TYPE;
3160: l_auto_waitlist_days NUMBER;
3161: l_auto_waitlist VARCHAR2(2) := 'N';
3162: l_waitlist_size NUMBER := 0;
3163:

Line 3177: FROM fnd_user

3173: FROM dual;
3174:
3175: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS
3176: SELECT user_name
3177: FROM fnd_user
3178: WHERE employee_id = l_owner_id
3179: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);
3180:
3181: CURSOR booking_csr(p_booking_id NUMBER) IS