APPS.GHR_SF52_API dependencies on FND_USER

Line 352: fnd_user usr

348: per.first_name,
349: per.last_name,
350: per.middle_names
351: from per_people_f per,
352: fnd_user usr
353: where upper(usr.user_name) = upper(p_1_user_name_acted_on)
354: and per.person_id = usr.employee_id
355: and l_effective_date
356: between effective_start_date

Line 367: fnd_user usr

363: per.first_name,
364: per.last_name,
365: per.middle_names
366: FROM per_people_f per,
367: fnd_user usr
368: WHERE usr.user_name = upper(p_1_user_name_acted_on)
369: AND per.person_id = usr.employee_id
370: AND trunc(sysdate)
371: BETWEEN effective_start_date

Line 2376: from fnd_user usr,

2372: select usr.employee_id,
2373: per.first_name,
2374: per.last_name,
2375: per.middle_names
2376: from fnd_user usr,
2377: per_people_f per
2378: where upper(p_u_user_name_acted_on) = upper(usr.user_name)
2379: and per.person_id = usr.employee_id
2380: and l_effective_date

Line 2390: FROM fnd_user usr,

2386: SELECT usr.employee_id,
2387: per.first_name,
2388: per.last_name,
2389: per.middle_names
2390: FROM fnd_user usr,
2391: per_people_f per
2392: WHERE usr.user_name = UPPER(p_u_user_name_acted_on)
2393: AND per.person_id = usr.employee_id
2394: AND trunc(sysdate)

Line 4478: from fnd_user usr,

4474: select usr.employee_id,
4475: per.first_name,
4476: per.last_name,
4477: per.middle_names
4478: from fnd_user usr,
4479: per_people_f per
4480: where upper(l_user_name) = upper(usr.user_name)
4481: and per.person_id = usr.employee_id
4482: and l_effective_date

Line 4492: FROM fnd_user usr,

4488: SELECT usr.employee_id,
4489: per.first_name,
4490: per.last_name,
4491: per.middle_names
4492: FROM fnd_user usr,
4493: per_people_f per
4494: WHERE usr.user_name = UPPER(l_user_name)
4495: AND per.person_id = usr.employee_id
4496: AND trunc(sysdate)

Line 4841: l_user_id fnd_user.user_id%type;

4837:
4838: l_proc varchar2(72) := g_package || 'print_sf50';
4839: l_set_print_options_status boolean;
4840: l_request_status number(15);
4841: l_user_id fnd_user.user_id%type;
4842:
4843: Cursor c_user_id is
4844: select user_id
4845: from fnd_user

Line 4845: from fnd_user

4841: l_user_id fnd_user.user_id%type;
4842:
4843: Cursor c_user_id is
4844: select user_id
4845: from fnd_user
4846: where user_name = p_user_name;
4847:
4848: begin
4849: If trunc(p_effective_date) > trunc(sysdate) then