APPS.HR_NZ_HOLIDAYS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1174: FROM hr_soft_coding_keyflex scl,

1170: CURSOR csr_scl(c_business_group_id NUMBER
1171: ,c_calculation_date DATE
1172: ,c_assignment_id NUMBER) IS
1173: SELECT TO_DATE(scl.segment2,'YYYY/MM/DD HH24:MI:SS')
1174: FROM hr_soft_coding_keyflex scl,
1175: per_assignments_f asg
1176: WHERE asg.assignment_id = c_assignment_id
1177: AND asg.business_group_id + 0 = c_business_group_id
1178: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id