APPS.BEN_ELECTION_INFORMATION dependencies on PAY_ELEMENT_ENTRIES_F

Line 808: pay_element_entries_f pee,

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
812: and pev.element_entry_value_id = prv.element_entry_value_id

Line 843: pay_element_entries_f ele,

839: --
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

Line 1405: pay_element_entries_f pee,

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
1408: and eev.element_entry_id = pee.element_entry_id
1409: and pee.element_link_id = elk.element_link_id