DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY dependencies on PAY_ELEMENT_ENTRIES_F

Line 111: ,pay_element_entries_f ee

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
114: AND p_effective_date BETWEEN asg1.effective_start_date
115: AND asg1.effective_end_date

Line 536: ,pay_element_entries_f ee

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
539: AND p_effective_date BETWEEN asg1.effective_start_date
540: AND asg1.effective_end_date

Line 794: ,pay_element_entries_f ee

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
798: ,pay_input_values_f pivf2

Line 1006: ,pay_element_entries_f ee

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'
1010: AND el.business_group_id = asg.business_group_id

Line 1715: ,pay_element_entries_f ee

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
1718: AND p_date_earned BETWEEN asg1.effective_start_date
1719: AND asg1.effective_end_date

Line 2556: ,pay_element_entries_f ee

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
2559: AND p_effective_date BETWEEN asg1.effective_start_date
2560: AND asg1.effective_end_date