APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on FND_USER

Line 1008: l_owner_username fnd_user.user_name%type;

1004: l_date_booking_placed date;
1005: l_current_date date;
1006: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1007: l_version_name ota_activity_versions.version_name%type;
1008: l_owner_username fnd_user.user_name%type;
1009: l_owner_id ota_events.owner_id%type;
1010: l_activity_version_id ota_activity_versions.activity_version_id%type;
1011: l_event_title ota_events.title%type;
1012: l_course_start_date ota_events.course_start_date%type;

Line 1126: FND_USER

1122: CURSOR csr_user(p_owner_id in number) IS
1123: SELECT
1124: USER_NAME
1125: FROM
1126: FND_USER
1127: WHERE
1128: Employee_id = p_owner_id
1129: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
1130:

Line 2771: FND_USER USR

2767:
2768: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2769: SELECT usr.user_name
2770: FROM OTA_EVENTS evt,
2771: FND_USER USR
2772: WHERE evt.event_id = p_event_id and
2773: usr.employee_id = evt.owner_id
2774: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')) ; --Bug 5676892
2775:

Line 2780: l_user_name FND_USER.USER_NAME%TYPE;

2776: l_api_result VARCHAR2(4000);
2777: l_api_from VARCHAR2(4000);
2778: l_api_to VARCHAR2(4000);
2779: l_event_id NUMBER;
2780: l_user_name FND_USER.USER_NAME%TYPE;
2781: BEGIN
2782:
2783: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2784: ,itemkey => itemkey

Line 2917: FND_USER USR

2913:
2914: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2915: SELECT usr.user_name
2916: FROM OTA_EVENTS evt,
2917: FND_USER USR
2918: WHERE evt.event_id = p_event_id and
2919: usr.employee_id = evt.owner_id
2920: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
2921:

Line 2940: l_user_name FND_USER.USER_NAME%TYPE;

2936: And OCU.category_usage_id = OFR.delivery_mode_id
2937: And OEV.event_id = p_event_id;
2938:
2939: l_event_id NUMBER;
2940: l_user_name FND_USER.USER_NAME%TYPE;
2941: l_booking_id ota_delegate_bookings.booking_id%type;
2942: l_notification_text varchar2(2000);
2943: l_status_type ota_booking_status_types.type%type;
2944: