215: cursor asgt_details is
216: --
217: select person.full_name,
218: asgt.assignment_number
219: from per_people_f PERSON,
220: per_assignments_f2 ASGT
221: where person.person_id = asgt.person_id
222: and asgt.assignment_id = p_assignment_id
223: and p_effective_end_date between asgt.effective_start_date
764: cursor asgt_details is
765: --
766: select person.full_name,
767: asgt.assignment_number
768: from per_people_f PERSON,
769: per_assignments_f2 ASGT
770: where person.person_id = asgt.person_id
771: and asgt.assignment_id = p_assignment_id
772: and p_effective_end_date between asgt.effective_start_date