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 1252: l_suffix per_all_people_f.title%type;

1248: --- 3671043 Bug fix
1249: l_log_text ghr_process_log.log_text%type;
1250: l_message_name ghr_process_log.message_name%type;
1251: l_log_date ghr_process_log.log_date%type;
1252: l_suffix per_all_people_f.title%type;
1253: l_last_name per_all_people_f.last_name%type;
1254:
1255:
1256: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)

Line 1253: l_last_name per_all_people_f.last_name%type;

1249: l_log_text ghr_process_log.log_text%type;
1250: l_message_name ghr_process_log.message_name%type;
1251: l_log_date ghr_process_log.log_date%type;
1252: l_suffix per_all_people_f.title%type;
1253: l_last_name per_all_people_f.last_name%type;
1254:
1255:
1256: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)
1257: IS

Line 1259: FROM per_all_people_f

1255:
1256: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)
1257: IS
1258: SELECT full_name name ,national_identifier ssn,last_name,first_name,middle_names, title
1259: FROM per_all_people_f
1260: WHERE person_id=p_person_id;
1261:
1262:
1263: l_business_group_id per_assignments_f.business_group_id%type;