578: select pos.leaving_reason
579: ,pos.actual_termination_date
580: ,paf.job_id
581: ,paf.assignment_id
582: from per_periods_of_service pos
583: ,per_all_assignments_f paf
584: where pos.date_start <= P_DATE_FROM
585: and pos.actual_termination_date is not null
586: and pos.actual_termination_date between P_DATE_FROM
602: select pos.leaving_reason
603: ,pos.actual_termination_date
604: ,paf.job_id
605: ,paf.assignment_id
606: from per_periods_of_service pos
607: ,per_all_assignments_f paf
608: where pos.date_start <= P_DATE_FROM
609: and pos.actual_termination_date is not null
610: and pos.actual_termination_date between