69: ,disb.disability_id
70: FROM per_all_assignments_f assg
71: ,per_all_people_f people
72: ,per_disabilities_f disb
73: ,per_jobs job
74: ,per_all_positions pos
75: ,per_periods_of_service period
76: ,hr_lookups hr1
77: ,hr_lookups hr2
572: ,fnd_date.canonical_to_date(cont.ctr_information2) expiry_date
573: FROM per_all_assignments_f assg
574: ,per_all_people_f people
575: ,per_contracts cont
576: ,per_jobs job
577: ,per_periods_of_service period
578: ,hr_all_organization_units org
579: ,hr_soft_coding_keyflex hsck
580: WHERE assg.person_id = people.person_id