Manage Employment Transaction Query

 select txnh.creation_date,txnh.transaction_id,pname.full_name,asg.assignment_number from fusion.hrc_txn_header txnh,per_person_names_f pname,per_all_assignments_f asg where txnh.object_id = asg.assignment_id and trunc(sysdate) between pname.effective_start_date and pname.effective_end_date and pname.name_Type ='GLOBAL' and txnh.process_owner='MngEmplProcessOwner' and pname.person_id= asg.person_id and asg.primary_flag='Y'

and trunc(sysdate) between asg.effective_start_Date and asg.effective_end_date

--and txnh.transaction_id = '300000059017108'