APPS.GHR_SF52_API dependencies on FND_USER

Line 347: fnd_user usr

343: per.first_name,
344: per.last_name,
345: per.middle_names
346: from per_people_f per,
347: fnd_user usr
348: where upper(usr.user_name) = upper(p_1_user_name_acted_on)
349: and per.person_id = usr.employee_id
350: and l_effective_date
351: between effective_start_date

Line 361: fnd_user usr

357: per.first_name,
358: per.last_name,
359: per.middle_names
360: FROM per_people_f per,
361: fnd_user usr
362: WHERE usr.user_name = upper(p_1_user_name_acted_on)
363: AND per.person_id = usr.employee_id
364: AND l_effective_date
365: BETWEEN effective_start_date

Line 2298: from fnd_user usr,

2294: select usr.employee_id,
2295: per.first_name,
2296: per.last_name,
2297: per.middle_names
2298: from fnd_user usr,
2299: per_people_f per
2300: where upper(p_u_user_name_acted_on) = upper(usr.user_name)
2301: and per.person_id = usr.employee_id
2302: and l_effective_date

Line 2311: FROM fnd_user usr,

2307: SELECT usr.employee_id,
2308: per.first_name,
2309: per.last_name,
2310: per.middle_names
2311: FROM fnd_user usr,
2312: per_people_f per
2313: WHERE usr.user_name = UPPER(p_u_user_name_acted_on)
2314: AND per.person_id = usr.employee_id
2315: AND l_effective_date

Line 4235: from fnd_user usr,

4231: select usr.employee_id,
4232: per.first_name,
4233: per.last_name,
4234: per.middle_names
4235: from fnd_user usr,
4236: per_people_f per
4237: where upper(l_user_name) = upper(usr.user_name)
4238: and per.person_id = usr.employee_id
4239: and l_effective_date

Line 4249: FROM fnd_user usr,

4245: SELECT usr.employee_id,
4246: per.first_name,
4247: per.last_name,
4248: per.middle_names
4249: FROM fnd_user usr,
4250: per_people_f per
4251: WHERE usr.user_name = UPPER(l_user_name)
4252: AND per.person_id = usr.employee_id
4253: AND l_effective_date

Line 4598: l_user_id fnd_user.user_id%type;

4594:
4595: l_proc varchar2(72) := g_package || 'print_sf50';
4596: l_set_print_options_status boolean;
4597: l_request_status number(15);
4598: l_user_id fnd_user.user_id%type;
4599:
4600: Cursor c_user_id is
4601: select user_id
4602: from fnd_user

Line 4602: from fnd_user

4598: l_user_id fnd_user.user_id%type;
4599:
4600: Cursor c_user_id is
4601: select user_id
4602: from fnd_user
4603: where user_name = p_user_name;
4604:
4605: begin
4606: If trunc(p_effective_date) > trunc(sysdate) then