eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_HOLIDAY_PAY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 112: ,pay_element_entry_values_f eev1

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
116: --AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 537: ,pay_element_entry_values_f eev1

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
541: --AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 795: ,pay_element_entry_values_f peevf1

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
799: WHERE paaf.assignment_id = p_assignment_id

Line 796: ,pay_element_entry_values_f peevf2

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

Line 1716: ,pay_element_entry_values_f eev1

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
1720: --AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 2557: ,pay_element_entry_values_f eev1

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