APPS.HR_NZ_ROUTES dependencies on HR_SOFT_CODING_KEYFLEX

Line 119: FROM hr_soft_coding_keyflex hsck

115: /* Bug 4259438 : Modified Cursor as part of performance fix */
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