410: /*
411: cursor csr_get_assignment is
412: select distinct pee.assignment_id assignment_id, asg.assignment_number
413: from pay_element_entries_f pee,
414: pay_element_links_f pel,
415: per_all_assignments_f asg
416: where pee.element_type_id = p_plan_ele_type_id
417: and pee.element_type_id = pel.element_type_id
418: and pee.element_link_id = pel.element_link_id
425:
426: cursor csr_get_assignment is
427: select distinct pee.assignment_id assignment_id, asg.assignment_number
428: from pay_element_entries_f pee,
429: pay_element_links_f pel,
430: per_all_assignments_f asg,
431: per_periods_of_service pds
432: where pee.element_type_id = p_plan_ele_type_id
433: and pee.element_type_id = pel.element_type_id