DBA Data[Home] [Help]

APPS.HR_DYNSQL dependencies on HR_SOFT_CODING_KEYFLEX

Line 2015: ,hr_soft_coding_keyflex SCL

2011: ,p_effective_date date
2012: ) is
2013: select to_number(SCL.segment1) tax_unit_id
2014: from per_all_assignments_f ASG
2015: ,hr_soft_coding_keyflex SCL
2016: where ASG.assignment_id = p_assignment_id
2017: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
2018: and p_effective_date between ASG.effective_start_date
2019: and ASG.effective_end_date;