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 2095: FND_USER USR

2091:
2092: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2093: SELECT usr.user_name
2094: FROM OTA_EVENTS evt,
2095: FND_USER USR
2096: WHERE evt.event_id = p_event_id and
2097: usr.employee_id = evt.owner_id
2098: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')) ; --Bug 5676892
2099:

Line 2104: l_user_name FND_USER.USER_NAME%TYPE;

2100: l_api_result VARCHAR2(4000);
2101: l_api_from VARCHAR2(4000);
2102: l_api_to VARCHAR2(4000);
2103: l_event_id NUMBER;
2104: l_user_name FND_USER.USER_NAME%TYPE;
2105: BEGIN
2106:
2107: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2108: ,itemkey => itemkey

Line 2241: FND_USER USR

2237:
2238: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2239: SELECT usr.user_name
2240: FROM OTA_EVENTS evt,
2241: FND_USER USR
2242: WHERE evt.event_id = p_event_id and
2243: usr.employee_id = evt.owner_id
2244: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
2245:

Line 2264: l_user_name FND_USER.USER_NAME%TYPE;

2260: And OCU.category_usage_id = OFR.delivery_mode_id
2261: And OEV.event_id = p_event_id;
2262:
2263: l_event_id NUMBER;
2264: l_user_name FND_USER.USER_NAME%TYPE;
2265: l_booking_id ota_delegate_bookings.booking_id%type;
2266: l_notification_text varchar2(2000);
2267: l_status_type ota_booking_status_types.type%type;
2268: