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_CPDF_STATRPT dependencies on PER_ALL_PEOPLE_F

Line 1283: l_suffix per_all_people_f.title%type;

1279: --- 3671043 Bug fix
1280: l_log_text ghr_process_log.log_text%type;
1281: l_message_name ghr_process_log.message_name%type;
1282: l_log_date ghr_process_log.log_date%type;
1283: l_suffix per_all_people_f.title%type;
1284: l_last_name per_all_people_f.last_name%type;
1285:
1286:
1287: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)

Line 1284: l_last_name per_all_people_f.last_name%type;

1280: l_log_text ghr_process_log.log_text%type;
1281: l_message_name ghr_process_log.message_name%type;
1282: l_log_date ghr_process_log.log_date%type;
1283: l_suffix per_all_people_f.title%type;
1284: l_last_name per_all_people_f.last_name%type;
1285:
1286:
1287: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)
1288: IS

Line 1291: FROM per_all_people_f

1287: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)
1288: IS
1289: --Bug # 9329643 added employee no
1290: SELECT full_name name ,national_identifier ssn,last_name,first_name,middle_names, title, employee_number
1291: FROM per_all_people_f
1292: WHERE person_id=p_person_id;
1293:
1294: --Bug # 9329643
1295: l_employee_number per_people_f.employee_number%TYPE;