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_ABSENCE dependencies on PAY_ELEMENT_ENTRIES_F

Line 146: ,pay_element_entries_f ee

142: ,per_all_people_f per
143: ,pay_element_links_f el
144: ,pay_element_types_f et
145: ,pay_input_values_f iv1
146: ,pay_element_entries_f ee
147: ,pay_element_entry_values_f eev1
148: WHERE asg1.assignment_id = l_asg_id
149: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date
150: AND l_eff_dt BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 444: ,pay_element_entries_f ee

440: ,per_all_people_f per
441: ,pay_element_links_f el
442: ,pay_element_types_f et
443: ,pay_input_values_f iv1
444: ,pay_element_entries_f ee
445: ,pay_element_entry_values_f eev1
446: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
447: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
448: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 723: ,pay_element_entries_f ee

719: ,per_all_people_f per
720: ,pay_element_links_f el
721: ,pay_element_types_f et
722: ,pay_input_values_f iv1
723: ,pay_element_entries_f ee
724: ,pay_element_entry_values_f eev1
725: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
726: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
727: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 758: ,pay_element_entries_f ee

754: ,per_all_people_f per
755: ,pay_element_links_f el
756: ,pay_element_types_f et
757: ,pay_input_values_f iv1
758: ,pay_element_entries_f ee
759: ,pay_element_entry_values_f eev1
760: WHERE asg1.assignment_id = l_asg_id
761: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date
762: AND l_eff_dt BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 906: ,pay_element_entries_f ee

902: SELECT greatest(fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE),csr_v_start_date) date_start,
903: least(fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE),csr_v_end_date) date_end
904: FROM per_all_assignments_f paaf
905: ,pay_element_types_f et
906: ,pay_element_entries_f ee
907: ,pay_element_entry_values_f peevf1
908: ,pay_element_entry_values_f peevf2
909: ,pay_input_values_f pivf1
910: ,pay_input_values_f pivf2

Line 3498: ,pay_element_entries_f ee

3494: ,per_all_people_f per
3495: ,pay_element_links_f el
3496: ,pay_element_types_f et
3497: ,pay_input_values_f iv1
3498: ,pay_element_entries_f ee
3499: ,pay_element_entry_values_f eev1
3500: WHERE asg1.assignment_id = csr_v_assignment_id --34040 --l_asg_id
3501: AND p_payroll_end BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3502: AND p_payroll_end BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 3594: ,pay_element_entries_f ee

3590: ,per_all_people_f per
3591: ,pay_element_links_f el
3592: ,pay_element_types_f et
3593: ,pay_input_values_f iv1
3594: ,pay_element_entries_f ee
3595: ,pay_element_entry_values_f eev1
3596: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
3597: AND p_pay_end_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3598: AND p_pay_end_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date