80: CURSOR other_assignments IS
81: SELECT DISTINCT ASG1.assignment_id
82: FROM per_assignments_f ASG1,
83: per_assignments_f ASG,
84: hr_soft_coding_keyflex SK
85: WHERE ASG.assignment_id = p_asst_id
86: AND ASG.payroll_id = p_payroll_id
87: AND ASG.person_id = ASG1.person_id
88: AND ASG.payroll_id = ASG1.payroll_id
151:
152: CURSOR work_schedule (p_assign_id NUMBER) IS
153: SELECT target.SEGMENT4
154: FROM
155: hr_soft_coding_keyflex target,
156: per_assignments_f ASSIGN
157: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
158: AND ASSIGN.effective_end_date
159: AND ASSIGN.assignment_id = p_assign_id