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.

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: l_forward_to_name ghr_groupboxes.name%TYPE;

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: l_forward_to_name ghr_groupboxes.name%TYPE;
265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

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: l_forward_to_name ghr_groupboxes.name%TYPE;
265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
266: l_2_user_name ghr_pa_routing_history.user_name%TYPE;

Line 277: l_employee_id per_people_f.person_id%type;

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

Line 346: from per_people_f per,

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

Line 360: FROM per_people_f per,

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

Line 2178: l_user_name_employee_id per_people_f.person_id%TYPE;

2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

Line 2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;

2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

Line 2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;

2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

Line 2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;

Line 2209: l_employee_id per_people_f.person_id%type;

2205: l_flag varchar2(1);
2206: l_information_type ghr_pa_request_info_types.information_type%type;
2207: l_set_print_options_status boolean;
2208: l_request_status number(15);
2209: l_employee_id per_people_f.person_id%type;
2210: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2211: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2212: l_approval_date date;
2213: l_sf50_approval_date date;

Line 2299: per_people_f per

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

Line 2312: per_people_f per

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
2316: BETWEEN effective_start_date

Line 4236: per_people_f per

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

Line 4250: per_people_f per

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
4254: BETWEEN effective_start_date