479: ,hr_soft_coding_keyflex hsck
480: ,per_assignments_f paf
481: ,per_periods_of_service pps
482: ,per_person_type_usages_f ptu
483: ,per_person_types ppt
484: where ppf.person_id = pps.person_id
485: and pps.actual_termination_date is not NULL
486: and pps.actual_termination_date
487: between to_date(g_start_date,'YYYY/MM/DD/')
801: ,hr_soft_coding_keyflex hsck
802: ,per_assignments_f paf
803: ,per_periods_of_service pps
804: ,per_person_type_usages_f ptu
805: ,per_person_types ppt
806: Where
807: ppf.person_id = pps.person_id
808: and pps.actual_termination_date is not NULL
809: and pps.actual_termination_date
855: ,hr_soft_coding_keyflex hsck
856: ,per_assignments_f paf
857: ,per_periods_of_service pps
858: ,per_person_type_usages_f ptu
859: ,per_person_types ppt
860: Where
861: ppf.person_id = pps.person_id
862: and pps.actual_termination_date is not NULL
863: and pps.actual_termination_date