DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 2019: FROM pay_assignment_link_usages_f usage

2015: AND asm.effective_end_date
2016: AND nvl(pel.organization_id,nvl(asm.organization_id,-1)) = nvl(asm.organization_id,-1)
2017: AND (pel.people_group_id IS NULL
2018: OR exists (SELECT 'X'
2019: FROM pay_assignment_link_usages_f usage
2020: WHERE usage.assignment_id = asm.assignment_id
2021: AND usage.element_link_id = pel.element_link_id
2022: AND p_date_worked BETWEEN usage.effective_start_date
2023: AND usage.effective_end_date))