DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 1949: FROM pay_assignment_link_usages_f usage

1945: AND asm.effective_end_date
1946: AND nvl(pel.organization_id,nvl(asm.organization_id,-1)) = nvl(asm.organization_id,-1)
1947: AND (pel.people_group_id IS NULL
1948: OR exists (SELECT 'X'
1949: FROM pay_assignment_link_usages_f usage
1950: WHERE usage.assignment_id = asm.assignment_id
1951: AND usage.element_link_id = pel.element_link_id
1952: AND p_date_worked BETWEEN usage.effective_start_date
1953: AND usage.effective_end_date))