DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY dependencies on PAY_INPUT_VALUES_F

Line 110: ,pay_input_values_f iv1

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

Line 535: ,pay_input_values_f iv1

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

Line 797: ,pay_input_values_f pivf1

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
799: WHERE paaf.assignment_id = p_assignment_id
800: AND p_effective_date BETWEEN paaf.effective_start_date
801: AND paaf.effective_end_date

Line 798: ,pay_input_values_f pivf2

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
799: WHERE paaf.assignment_id = p_assignment_id
800: AND p_effective_date BETWEEN paaf.effective_start_date
801: AND paaf.effective_end_date
802: AND et.element_name = 'Absence Details'

Line 1714: ,pay_input_values_f iv1

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

Line 2555: ,pay_input_values_f iv1

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