[Home] [Help]
49: AND ass.assignment_type = 'E'
50: UNION ALL
51: SELECT p_person_id, effective_start_date, effective_end_date, grade_id, job_id, position_id
52: FROM per_all_assignments_f ass,
53: per_cont_workers_x P
54: WHERE P.PERSON_ID = p_person_id
55: AND ass.assignment_id = p.assignment_id
56: AND p_date >= effective_start_date and p_date <= effective_end_date
57: AND ass.assignment_type = 'C')