[Home] [Help]
5: -- Function to get user_id for an employee.
6: -- Parameters:
7: -- IN p_employee_id
8: -- Return Value:
9: -- user_id (from fnd_user) or NULL if no user exists for
10: -- that employee_id
11: -- Note: this will return the first user_id that has an AP SSWA
12: -- responsibility, since that is the most likely useful user_id.
13: -- In other words, this function is NOT a generic employee_id->user_id
19: begin
20: begin
21: select fu.user_id
22: into l_user_id
23: from fnd_user fu
24: where fu.employee_id = p_employee_id
25: and sysdate >= fu.start_date
26: and sysdate <= nvl(fu.end_date, sysdate)
27: and rownum = 1;
90: into l_menu_id, l_responsibility_id
91: from (
92: select fr.menu_id, fr.responsibility_id
93: from fnd_responsibility fr,
94: fnd_user_resp_groups furg
95: where fr.application_id = 200
96: and fr.version = 'W'
97: and furg.user_id = p_user_id
98: and furg.responsibility_id = fr.responsibility_id
301: select asp.default_exchange_rate_type
302: into l_exchange_rate_type
303: from per_employees_x pex,
304: ap_system_parameters_all asp,
305: fnd_user fu
306: where
307: pex.set_of_books_id = asp.set_of_books_id and
308: fu.employee_id = pex.employee_id and
309: fu.user_id = p_userid and