DBA Data[Home] [Help]

APPS.BEN_MANAGE_OVERRIDE dependencies on PAY_ELEMENT_ENTRIES_F

Line 1682: from pay_element_entries_f ele,

1678: ele.effective_end_date,
1679: ele.object_version_number,
1680: ele.creator_type,
1681: ele.creator_id
1682: from pay_element_entries_f ele,
1683: pay_element_links_f elk,
1684: pay_element_types_f elt,
1685: per_all_assignments_f asg
1686: where ele.effective_start_date = (select min(ele2.effective_start_date)

Line 1687: from pay_element_entries_f ele2

1683: pay_element_links_f elk,
1684: pay_element_types_f elt,
1685: per_all_assignments_f asg
1686: where ele.effective_start_date = (select min(ele2.effective_start_date)
1687: from pay_element_entries_f ele2
1688: where ele2.element_entry_id
1689: = ele.element_entry_id)
1690: and ele.effective_start_date > p_effective_date
1691: and asg.person_id = p_person_id