DBA Data[Home] [Help]

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;