DBA Data[Home] [Help]

APPS.HXT_GEN_AAI dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 84: from pay_assignment_link_usages_f usage

80: = nvl(asm.organization_id,-1)
81: and (ell.people_group_id is null
82: or exists
83: (select 1
84: from pay_assignment_link_usages_f usage
85: where usage.assignment_id = asm.assignment_id
86: and usage.element_link_id = ell.element_link_id
87: and p_effective_start_date
88: between usage.effective_start_date

Line 166: from pay_assignment_link_usages_f usage

162: = nvl(asm.organization_id,-1)
163: and (ell.people_group_id is null
164: or exists
165: (select 1
166: from pay_assignment_link_usages_f usage
167: where usage.assignment_id = asm.assignment_id
168: and usage.element_link_id = ell.element_link_id
169: and p_effective_start_date
170: between usage.effective_start_date