APPS.BEN_ELECTION_INFORMATION dependencies on PAY_ELEMENT_ENTRIES_F

Line 723: pay_element_entries_f pee,

719: or exists
720: (select 'x'
721: from per_all_assignments_f asg,
722: pay_element_links_f pel,
723: pay_element_entries_f pee,
724: pay_element_entry_values_f pev
725: where pel.element_type_id = p_element_type_id
726: and pee.element_entry_id = pev.element_entry_id
727: and pev.element_entry_value_id = prv.element_entry_value_id

Line 758: pay_element_entries_f ele,

754: --
755: cursor c_ele_entry (p_element_entry_value_id number) is
756: select elk.element_type_id
757: from pay_element_entry_values_f elv,
758: pay_element_entries_f ele,
759: pay_element_links_f elk
760: where elv.element_entry_value_id = p_element_entry_value_id
761: and elv.element_entry_id = ele.element_entry_id
762: and elv.effective_start_date between ele.effective_start_date

Line 1243: pay_element_entries_f pee,

1239: -- pee.assignment_id,
1240: pee.effective_end_date
1241: from pay_element_links_f elk,
1242: per_all_assignments_f asg,
1243: pay_element_entries_f pee,
1244: pay_element_entry_values_f eev
1245: where eev.element_entry_value_id = p_element_entry_value_id
1246: and eev.element_entry_id = pee.element_entry_id
1247: and pee.element_link_id = elk.element_link_id