APPS.PAY_SE_HOLIDAY_PAY dependencies on PAY_ELEMENT_TYPES_F

Line 109: ,pay_element_types_f et

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
113: WHERE asg1.assignment_id = p_assignment_id

Line 534: ,pay_element_types_f et

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
538: WHERE asg1.assignment_id = p_assignment_id

Line 793: ,pay_element_types_f et

789: CURSOR csr_get_vacation_days
790: IS
791: SELECT NVL (SUM (peevf2.screen_entry_value), 0)
792: FROM per_all_assignments_f paaf
793: ,pay_element_types_f et
794: ,pay_element_entries_f ee
795: ,pay_element_entry_values_f peevf1
796: ,pay_element_entry_values_f peevf2
797: ,pay_input_values_f pivf1

Line 1005: ,pay_element_types_f et

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
1009: AND et.legislation_code = 'SE'

Line 1713: ,pay_element_types_f et

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
1717: WHERE asg1.assignment_id = p_assignment_id

Line 2554: ,pay_element_types_f et

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
2558: WHERE asg1.assignment_id = p_assignment_id