[Home] [Help]
170: BEGIN
171: IF ass_number is not null THEN
172: select substr(ppos.name,1,30)
173: into l_position_name
174: from per_assignments_f paf,
175: per_positions ppos
176: where paf.position_id = ppos.position_id
177: --and paf.assignment_id = assignment_id
178: and paf.assignment_id = v_assignment_id