DBA Data[Home] [Help]

APPS.BEN_ELEMENT_ENTRY dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 2185: from pay_assignment_link_usages_f alu

2181: ,c_eff_date date
2182: )
2183: is
2184: select null
2185: from pay_assignment_link_usages_f alu
2186: where alu.assignment_id = c_asg_id
2187: and alu.element_link_id = c_elk_id
2188: and c_eff_date
2189: between alu.effective_start_date and alu.effective_end_date;

Line 2232: from pay_assignment_link_usages_f alu

2228: and (el.employment_category is null or
2229: el.employment_category = asg.employment_category)
2230: and (el.people_group_id is null or exists
2231: (select null
2232: from pay_assignment_link_usages_f alu
2233: where alu.assignment_id = asg.assignment_id
2234: and alu.element_link_id = el.element_link_id
2235: and c_eff_date between alu.effective_start_date
2236: and alu.effective_end_date)