eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GHR_SF52_API dependencies on PER_PEOPLE_F

Line 259: l_user_name_employee_id per_people_f.person_id%TYPE;

255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;
262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;

Line 260: l_user_name_emp_first_name per_people_f.first_name%TYPE;

256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;
262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: -- Modified to consider 100 characters as user name

Line 261: l_user_name_emp_last_name per_people_f.last_name%TYPE;

257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;
262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: -- Modified to consider 100 characters as user name
265: l_forward_to_name varchar2(100);

Line 262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;
262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: -- Modified to consider 100 characters as user name
265: l_forward_to_name varchar2(100);
266: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

Line 278: l_employee_id per_people_f.person_id%type;

274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;
276: l_flag varchar2(1);
277: l_position_id hr_all_positions_f.position_id%type;
278: l_employee_id per_people_f.person_id%type;
279: l_approval_date date;
280: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
282: l_sf50_approval_date date;

Line 351: from per_people_f per,

347: select usr.employee_id,
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

Line 366: FROM per_people_f per,

362: SELECT usr.employee_id,
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)

Line 2252: l_user_name_employee_id per_people_f.person_id%TYPE;

2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

Line 2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;

2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

Line 2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;

2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

Line 2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;

Line 2283: l_employee_id per_people_f.person_id%type;

2279: l_flag varchar2(1);
2280: l_information_type ghr_pa_request_info_types.information_type%type;
2281: l_set_print_options_status boolean;
2282: l_request_status number(15);
2283: l_employee_id per_people_f.person_id%type;
2284: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2285: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2286: l_approval_date date;
2287: l_sf50_approval_date date;

Line 2377: per_people_f per

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
2381: between effective_start_date

Line 2391: per_people_f per

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)
2395: BETWEEN effective_start_date

Line 4479: per_people_f per

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
4483: between effective_start_date

Line 4493: per_people_f per

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)
4497: BETWEEN effective_start_date