DBA Data[Home] [Help]

APPS.BEN_ELEMENT_ENTRY dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 2219: from pay_assignment_link_usages_f alu

2215: ,c_eff_date date
2216: )
2217: is
2218: select null
2219: from pay_assignment_link_usages_f alu
2220: where alu.assignment_id = c_asg_id
2221: and alu.element_link_id = c_elk_id
2222: and c_eff_date
2223: between alu.effective_start_date and alu.effective_end_date;

Line 2266: from pay_assignment_link_usages_f alu

2262: and (el.employment_category is null or
2263: el.employment_category = asg.employment_category)
2264: and (el.people_group_id is null or exists
2265: (select null
2266: from pay_assignment_link_usages_f alu
2267: where alu.assignment_id = asg.assignment_id
2268: and alu.element_link_id = el.element_link_id
2269: and c_eff_date between alu.effective_start_date
2270: and alu.effective_end_date)