1245: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
1246:
1247: l_assignments_f_rec assignments_f_cur%ROWTYPE;
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;
1246:
1247: l_assignments_f_rec assignments_f_cur%ROWTYPE;
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:
1247: l_assignments_f_rec assignments_f_cur%ROWTYPE;
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: