Content Comparison

select ps.name, ps.empl_record_no, ps.empl_status, ps.eac_division_desc, ps.eac_branch_desc, ps.eac_section_desc, 
ps.grade, initial_hire.grade as initial_grade, ps.tenure_code, ps.tenure_desc, ps.tenure_year, ps.univ_appt_date, ps.tenure_effective_date,
initial_hire.pers_reason_effective_date as hire_date, last_promotion.pers_reason_effective_date as promotion_date
from edadba.psempl ps, 
(select * from 
(select employee_alt_id, empl_record_no, grade, pers_reason_effective_date, row_number()  
  over(partition by employee_alt_id order by pers_reason_effective_date desc ) as sort_column  
  from edadba.hr_ps_report_tbl where employee_alt_id='22410796' and empl_record_no=1 and pers_action in ('HIR','HRC')) 
   where sort_column = 1) initial_hire,
(select * from 
(select employee_alt_id, empl_record_no, grade, pers_reason_effective_date, row_number()  
  over(partition by employee_alt_id order by pers_reason_effective_date desc ) as sort_column  
  from edadba.hr_ps_report_tbl where employee_alt_id='22410796' and empl_record_no=1 and pers_action='PRO') 
   where sort_column = 1) last_promotion   
where ps.employee_alt_id='22410796' and 
ps.employee_alt_id=initial_hire.employee_alt_id and 
ps.empl_record_no=initial_hire.empl_record_no and 
ps.employee_alt_id=last_promotion.employee_alt_id(+) and 
ps.empl_record_no=last_promotion.empl_record_no(+);

(select * from
(select employee_alt_id, empl_record_no, grade, pers_reason_effective_date, row_number()  
  over(partition by employee_alt_id order by pers_reason_effective_date desc ) as sort_column  
  from edadba.hr_ps_report_tbl where employee_alt_id='10196903' and empl_record_no=1 and pers_action='PRO') 
   where sort_column = 1);