[Home] [Help]
689:
690: FROM
691: per_all_assignments_f pas,
692: per_periods_of_service pos,
693: per_periods_of_placement pop
694: WHERE pas.person_id = pop.person_id (+)
695: AND pas.person_id = pos.person_id (+)
696: order by pas.business_group_id,pas.assignment_id,pas.effective_start_date;
697: