[Home] [Help]
601: -- Cursor to get information about assignment set
602: CURSOR csr_get_asg_set_info(c_asg_set_id NUMBER)
603: IS
604: SELECT formula_id
605: FROM hr_assignment_sets ags
606: WHERE assignment_set_id = c_asg_set_id
607: AND EXISTS(SELECT 1
608: FROM hr_assignment_set_criteria agsc
609: WHERE agsc.assignment_set_id = ags.assignment_set_id);