APPS.HR_DYNSQL dependencies on HR_SOFT_CODING_KEYFLEX
Line 2050: ,hr_soft_coding_keyflex SCL
2046: ,p_effective_date date
2047: ) is
2048: select to_number(SCL.segment1) tax_unit_id
2049: from per_all_assignments_f ASG 2050: ,hr_soft_coding_keyflex SCL 2051: where ASG.assignment_id = p_assignment_id
2052: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
2053: and p_effective_date between ASG.effective_start_date
2054: and ASG.effective_end_date;