APPS.HR_NZ_ROUTES dependencies on PER_ASSIGNMENTS_F

Line 120: , per_assignments_f paaf

116: CURSOR csr_ann_date
117: IS
118: SELECT to_date(segment2,'YYYY/MM/DD HH24:MI:SS')
119: FROM hr_soft_coding_keyflex hsck
120: , per_assignments_f paaf
121: , pay_assignment_actions paav
122: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
123: AND paav.assignment_action_id = p_assignment_action_id
124: AND paav.assignment_id = paaf.assignment_id