APPS.BEN_ELECTION_INFORMATION dependencies on PAY_ELEMENT_LINKS_F

Line 807: pay_element_links_f pel,

803: and (prv.acty_base_rt_id = p_acty_base_rt_id
804: or exists
805: (select 'x'
806: from per_all_assignments_f asg,
807: pay_element_links_f pel,
808: pay_element_entries_f pee,
809: pay_element_entry_values_f pev
810: where pel.element_type_id = p_element_type_id
811: and pee.element_entry_id = pev.element_entry_id

Line 844: pay_element_links_f elk

840: cursor c_ele_entry (p_element_entry_value_id number) is
841: select elk.element_type_id
842: from pay_element_entry_values_f elv,
843: pay_element_entries_f ele,
844: pay_element_links_f elk
845: where elv.element_entry_value_id = p_element_entry_value_id
846: and elv.element_entry_id = ele.element_entry_id
847: and elv.effective_start_date between ele.effective_start_date
848: and ele.effective_end_date

Line 1403: from pay_element_links_f elk,

1399: -- asg.payroll_id,
1400: pee.element_entry_id,
1401: -- pee.assignment_id,
1402: pee.effective_end_date
1403: from pay_element_links_f elk,
1404: per_all_assignments_f asg,
1405: pay_element_entries_f pee,
1406: pay_element_entry_values_f eev
1407: where eev.element_entry_value_id = p_element_entry_value_id