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_AE_ELEMENT_TEMPLATE_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 142: FROM per_absence_attendances paa

138:
139: CURSOR csr_get_day_range IS
140: SELECT paa.date_start start_date
141: ,paa.date_end end_date
142: FROM per_absence_attendances paa
143: ,per_absence_attendance_types paat
144: ,per_all_assignments_f asg
145: WHERE paat.absence_category ='UL'
146: AND paat.business_group_id = paa.business_group_id

Line 156: FROM per_absence_attendances paa

152: AND paa.date_end between p_start_date AND p_end_date)
153: UNION
154: SELECT paa.date_start start_date
155: ,p_end_date end_date
156: FROM per_absence_attendances paa
157: ,per_absence_attendance_types paat
158: ,per_all_assignments_f asg
159: WHERE paat.absence_category ='UL'
160: AND paat.business_group_id = paa.business_group_id

Line 170: FROM per_absence_attendances paa

166: AND paa.date_end > p_end_date)
167: UNION
168: SELECT p_start_date start_date
169: ,paa.date_end end_date
170: FROM per_absence_attendances paa
171: ,per_absence_attendance_types paat
172: ,per_all_assignments_f asg
173: WHERE paat.absence_category ='UL'
174: AND paat.business_group_id = paa.business_group_id

Line 184: FROM per_absence_attendances paa

180: AND paa.date_end between p_start_date AND p_end_date)
181: UNION
182: SELECT p_start_date start_date
183: ,p_end_date end_date
184: FROM per_absence_attendances paa
185: ,per_absence_attendance_types paat
186: ,per_all_assignments_f asg
187: WHERE paat.absence_category ='UL'
188: AND paat.business_group_id = paa.business_group_id