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_SS_RPA_CREATION dependencies on PER_PEOPLE_F

Line 66: l_employee_number per_people_f.employee_number%type;

62: l_object_version_number ghr_pa_requests.object_version_number%type;
63: l_proc varchar2(72) := g_package || 'create_sf52_fegli';
64: l_log_text varchar2(2000);
65: l_full_name VARCHAR2(380);
66: l_employee_number per_people_f.employee_number%type;
67: l_employee_first_name per_people_f.first_name%type;
68: l_employee_last_name per_people_f.last_name%type;
69: l_employee_middle_names per_people_f.middle_names%type;
70: l_wrk_sch ghr_pa_requests.work_schedule%type;

Line 67: l_employee_first_name per_people_f.first_name%type;

63: l_proc varchar2(72) := g_package || 'create_sf52_fegli';
64: l_log_text varchar2(2000);
65: l_full_name VARCHAR2(380);
66: l_employee_number per_people_f.employee_number%type;
67: l_employee_first_name per_people_f.first_name%type;
68: l_employee_last_name per_people_f.last_name%type;
69: l_employee_middle_names per_people_f.middle_names%type;
70: l_wrk_sch ghr_pa_requests.work_schedule%type;
71: l_fegli_element_value ghr_pa_requests.fegli%type;

Line 68: l_employee_last_name per_people_f.last_name%type;

64: l_log_text varchar2(2000);
65: l_full_name VARCHAR2(380);
66: l_employee_number per_people_f.employee_number%type;
67: l_employee_first_name per_people_f.first_name%type;
68: l_employee_last_name per_people_f.last_name%type;
69: l_employee_middle_names per_people_f.middle_names%type;
70: l_wrk_sch ghr_pa_requests.work_schedule%type;
71: l_fegli_element_value ghr_pa_requests.fegli%type;
72: l_elig_exp varchar2(30);

Line 69: l_employee_middle_names per_people_f.middle_names%type;

65: l_full_name VARCHAR2(380);
66: l_employee_number per_people_f.employee_number%type;
67: l_employee_first_name per_people_f.first_name%type;
68: l_employee_last_name per_people_f.last_name%type;
69: l_employee_middle_names per_people_f.middle_names%type;
70: l_wrk_sch ghr_pa_requests.work_schedule%type;
71: l_fegli_element_value ghr_pa_requests.fegli%type;
72: l_elig_exp varchar2(30);
73: l_event_code varchar2(30);

Line 253: FROM PER_PEOPLE_F

249: middle_names,
250: national_identifier,
251: date_of_birth,
252: employee_number
253: FROM PER_PEOPLE_F
254: WHERE person_id = p_person_id
255: AND p_effective_date between effective_start_date and effective_end_date;
256:
257: CURSOR get_assignment_dtls

Line 280: l_employee_number per_people_f.employee_number%type;

276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
278: l_object_version_number ghr_pa_remarks.object_version_number%type;
279: l_full_name VARCHAR2(380);
280: l_employee_number per_people_f.employee_number%type;
281: l_routing_group_id ghr_pa_requests.routing_group_id%type;
282: l_old_fegli ghr_pa_requests.fegli%type;
283: fegli_error exception;
284: l_log_text varchar2(2000);

Line 286: l_personnel_officer_name per_people_f.full_name%type;

282: l_old_fegli ghr_pa_requests.fegli%type;
283: fegli_error exception;
284: l_log_text varchar2(2000);
285: l_dummy_char varchar2(150);
286: l_personnel_officer_name per_people_f.full_name%type;
287: l_groupbox_id ghr_groupboxes.groupbox_id%type;
288: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
289: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
290: l_scd_leave varchar2(50);

Line 971: l_employee_number per_people_f.employee_number%type;

967: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
968: l_iprh_object_version_number ghr_pa_routing_history.object_version_number%type;
969: l_sf52_rec ghr_pa_requests%rowtype;
970: l_full_name VARCHAR2(380);
971: l_employee_number per_people_f.employee_number%type;
972: l_routing_group_id ghr_pa_requests.routing_group_id%type;
973: fegli_upd_error exception;
974: fegli_shadow_upd_error exception;
975: l_log_text varchar2(2000);

Line 976: l_personnel_officer_name per_people_f.full_name%type;

972: l_routing_group_id ghr_pa_requests.routing_group_id%type;
973: fegli_upd_error exception;
974: fegli_shadow_upd_error exception;
975: l_log_text varchar2(2000);
976: l_personnel_officer_name per_people_f.full_name%type;
977: l_groupbox_id ghr_groupboxes.groupbox_id%type;
978: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
979: l_object_version_number number;
980: l_result BOOLEAN;