[Home] [Help]
63: SELECT formula_id
64: FROM hr_assignment_sets ags
65: WHERE assignment_set_id = c_asg_set_id
66: AND EXISTS(SELECT 1
67: FROM hr_assignment_set_criteria agsc
68: WHERE agsc.assignment_set_id = ags.assignment_set_id);
69: -- Cursor to get assignment ids from asg set amendments
70: CURSOR csr_get_asg_amnd(c_asg_set_id NUMBER)
71: IS