DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PER_ALL_ASSIGNMENTS_F

Line 2968: , per_all_assignments_f asg

2964: , ee.effective_start_date
2965: from pay_element_entries_f ee
2966: , pay_element_types_f et
2967: , pay_element_links_f el
2968: , per_all_assignments_f asg
2969: where el.element_link_id = ee.element_link_id
2970: and et.element_type_id = el.element_type_id
2971: and ee.assignment_id = asg.assignment_id
2972: and l_effective_date between ee.effective_start_date

Line 2996: , per_all_assignments_f asg

2992: select null
2993: from pay_element_entries_f ee
2994: , pay_element_types_f et
2995: , pay_element_links_f el
2996: , per_all_assignments_f asg
2997: where el.element_link_id = ee.element_link_id
2998: and et.element_type_id = el.element_type_id
2999: and ee.assignment_id = asg.assignment_id
3000: and ee.effective_start_date > l_effective_date