DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PER_ALL_ASSIGNMENTS_F

Line 2963: , per_all_assignments_f asg

2959: , ee.effective_start_date
2960: from pay_element_entries_f ee
2961: , pay_element_types_f et
2962: , pay_element_links_f el
2963: , per_all_assignments_f asg
2964: where el.element_link_id = ee.element_link_id
2965: and et.element_type_id = el.element_type_id
2966: and ee.assignment_id = asg.assignment_id
2967: and l_effective_date between ee.effective_start_date

Line 2988: , per_all_assignments_f asg

2984: select null
2985: from pay_element_entries_f ee
2986: , pay_element_types_f et
2987: , pay_element_links_f el
2988: , per_all_assignments_f asg
2989: where el.element_link_id = ee.element_link_id
2990: and et.element_type_id = el.element_type_id
2991: and ee.assignment_id = asg.assignment_id
2992: and ee.effective_start_date > l_effective_date