APPS.PAY_SE_HOLIDAY_PAY dependencies on PAY_ELEMENT_LINKS_F

Line 108: , pay_element_links_f el

104: SELECT DISTINCT eev1.screen_entry_value attendance_type_id
105: FROM per_all_assignments_f asg1
106: --,per_all_assignments_f asg2
107: -- ,per_all_people_f per
108: , pay_element_links_f el
109: ,pay_element_types_f et
110: ,pay_input_values_f iv1
111: ,pay_element_entries_f ee
112: ,pay_element_entry_values_f eev1

Line 533: , pay_element_links_f el

529: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
530: FROM per_all_assignments_f asg1
531: --,per_all_assignments_f asg2
532: -- ,per_all_people_f per
533: , pay_element_links_f el
534: ,pay_element_types_f et
535: ,pay_input_values_f iv1
536: ,pay_element_entries_f ee
537: ,pay_element_entry_values_f eev1

Line 1004: ,pay_element_links_f el

1000: )
1001: IS
1002: SELECT 1
1003: FROM per_all_assignments_f asg
1004: ,pay_element_links_f el
1005: ,pay_element_types_f et
1006: ,pay_element_entries_f ee
1007: WHERE asg.assignment_id = p_assignment_id
1008: AND et.element_name = p_element_name

Line 1712: , pay_element_links_f el

1708: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
1709: FROM per_all_assignments_f asg1
1710: --,per_all_assignments_f asg2
1711: -- ,per_all_people_f per
1712: , pay_element_links_f el
1713: ,pay_element_types_f et
1714: ,pay_input_values_f iv1
1715: ,pay_element_entries_f ee
1716: ,pay_element_entry_values_f eev1

Line 2553: ,pay_element_links_f el

2549: CURSOR csr_attendance_category_id
2550: IS
2551: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
2552: FROM per_all_assignments_f asg1
2553: ,pay_element_links_f el
2554: ,pay_element_types_f et
2555: ,pay_input_values_f iv1
2556: ,pay_element_entries_f ee
2557: ,pay_element_entry_values_f eev1