APPS.OTA_EL_ENROLL_SS dependencies on FND_USER

Line 115: FND_USER

111: CURSOR csr_user(p_owner_id in number) IS
112: SELECT
113: USER_NAME
114: FROM
115: FND_USER
116: WHERE
117: Employee_id = p_owner_id ;
118:
119: CURSOR csr_activity(p_activity_version_id number )

Line 179: l_owner_username fnd_user.user_name%type;

175: l_course_end_date ota_events.course_end_date%type;
176: l_owner_id ota_events.owner_id%type;
177: l_activity_version_id ota_activity_versions.activity_version_id%type;
178: l_version_name ota_activity_versions.version_name%type;
179: l_owner_username fnd_user.user_name%type;
180: --Bug#2197997 commenting out completeactivity call.
181: -- l_return boolean;
182: l_offering_id ota_events.offering_id%type;
183: l_booking_status_used varchar2(20);

Line 1219: FND_USER

1215: CURSOR C_USER IS
1216: SELECT
1217: EMPLOYEE_ID
1218: FROM
1219: FND_USER
1220: WHERE
1221: user_id = l_current_user_id ;
1222:
1223: BEGIN

Line 1907: FND_USER USR

1903: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
1904: SELECT usr.user_name,
1905: evt.offering_id
1906: FROM OTA_EVENTS evt,
1907: FND_USER USR
1908: WHERE evt.event_id = p_event_id and
1909: usr.employee_id = evt.owner_id;
1910:
1911:

Line 1924: l_user_name FND_USER.USER_NAME%TYPE;

1920: l_api_result VARCHAR2(4000);
1921: l_api_from VARCHAR2(4000);
1922: l_api_to VARCHAR2(4000);
1923: l_event_id NUMBER;
1924: l_user_name FND_USER.USER_NAME%TYPE;
1925: l_offering_id ota_events.offering_id%type;
1926: l_booking_id ota_delegate_bookings.booking_id%type;
1927: l_version_name ota_activity_versions.version_name%type;
1928: l_notification_text varchar2(2000);

Line 2306: fnd_user_resp_groups furg,

2302: cursor getResp(l_user_id in varchar2) is
2303: select fr.menu_id, furg.responsibility_id,
2304: furg.security_group_id, furg.responsibility_application_id
2305: from fnd_responsibility fr,
2306: fnd_user_resp_groups furg,
2307: fnd_user fu
2308: where fu.USER_ID = l_user_id
2309: and fu.START_DATE <= sysdate
2310: and (fu.END_DATE is null or fu.END_DATE > sysdate)

Line 2307: fnd_user fu

2303: select fr.menu_id, furg.responsibility_id,
2304: furg.security_group_id, furg.responsibility_application_id
2305: from fnd_responsibility fr,
2306: fnd_user_resp_groups furg,
2307: fnd_user fu
2308: where fu.USER_ID = l_user_id
2309: and fu.START_DATE <= sysdate
2310: and (fu.END_DATE is null or fu.END_DATE > sysdate)
2311: and furg.USER_ID = fu.USER_ID

Line 2338: -- from FND_USER

2334: close getFunctionId;
2335: -- Get user ID of current user (If not available)
2336: -- select USER_ID
2337: -- into l_user_id
2338: -- from FND_USER
2339: -- where USER_NAME = l_username;
2340:
2341: -- Get responsibility ID
2342: