DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 173: FROM pay_assignment_link_usages_f usage

169: AND nvl(ell.organization_id,nvl(asm.organization_id,-1)) =
170: nvl(asm.organization_id,-1)
171: AND (ell.people_group_id is null
172: or exists (SELECT 'x'
173: FROM pay_assignment_link_usages_f usage
174: WHERE usage.assignment_id = asm.assignment_id
175: AND usage.element_link_id = ell.element_link_id
176: AND p_date_worked BETWEEN usage.effective_start_date
177: AND usage.effective_end_date))