166:
167: IF ( p_assignment_id IS NOT NULL) THEN
168: SELECT jobs.name
169: INTO p_job
170: FROM per_jobs_tl jobs , per_all_assignments_f assign,
171: ( SELECT assignment.assignment_id , max(assignment.effective_end_date)end_date
172: FROM per_all_assignments_f assignment
173: WHERE assignment.assignment_id = p_assignment_id GROUP BY assignment_id) b
174: WHERE