[Home] [Help]
4945: p_subhdr_ghr_to_dt date
4946: ) is
4947: select
4948: distinct pos.position_id position_id
4949: from ghr_pa_history gph ,
4950: HR_ALL_POSITIONS_F pos
4951: where ( (gph.table_name = 'HR_ALL_POSITIONS_F'
4952: and pos.POSITION_ID = gph.information1 )
4953: or (gph.table_name = 'PER_POSITION_EXTRA_INFO'