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.EDW_HR_MVMNT_TYP_M_SIZING dependencies on HRI_EDW_EVENT_HRCHYS

Line 198: hri_edw_event_hrchys gns

194: avg(nvl(vsize(gns.event_code),0))
195: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))
196: ,avg(nvl(vsize(gns.event_id),0))
197: FROM
198: hri_edw_event_hrchys gns
199: WHERE gns.level_number = 1
200: AND gns.hierarchy = 'Gain'
201: AND gns.last_update_date BETWEEN p_from_date AND p_to_date;
202:

Line 209: hri_edw_event_hrchys gns

205: avg(nvl(vsize(gns.event_code),0))
206: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))
207: ,avg(nvl(vsize(gns.event_id),0))
208: FROM
209: hri_edw_event_hrchys gns
210: WHERE gns.level_number = 2
211: AND gns.hierarchy = 'Gain'
212: AND gns.last_update_date BETWEEN p_from_date AND p_to_date;
213:

Line 220: hri_edw_event_hrchys gns

216: avg(nvl(vsize(gns.event_code),0))
217: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))
218: ,avg(nvl(vsize(gns.event_id),0))
219: FROM
220: hri_edw_event_hrchys gns
221: WHERE gns.level_number = 3
222: AND gns.hierarchy = 'Gain'
223: AND gns.last_update_date BETWEEN p_from_date AND p_to_date;
224:

Line 233: hri_edw_event_hrchys lss

229: avg(nvl(vsize(lss.event_code),0))
230: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))
231: ,avg(nvl(vsize(lss.event_id),0))
232: FROM
233: hri_edw_event_hrchys lss
234: WHERE lss.level_number = 1
235: AND lss.hierarchy = 'Loss'
236: AND lss.last_update_date BETWEEN p_from_date AND p_to_date;
237:

Line 244: hri_edw_event_hrchys lss

240: avg(nvl(vsize(lss.event_code),0))
241: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))
242: ,avg(nvl(vsize(lss.event_id),0))
243: FROM
244: hri_edw_event_hrchys lss
245: WHERE lss.level_number = 2
246: AND lss.hierarchy = 'Loss'
247: AND lss.last_update_date BETWEEN p_from_date AND p_to_date;
248:

Line 255: hri_edw_event_hrchys lss

251: avg(nvl(vsize(lss.event_code),0))
252: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))
253: ,avg(nvl(vsize(lss.event_id),0))
254: FROM
255: hri_edw_event_hrchys lss
256: WHERE lss.level_number = 3
257: AND lss.hierarchy = 'Loss'
258: AND lss.last_update_date BETWEEN p_from_date AND p_to_date;
259:

Line 268: hri_edw_event_hrchys rec

264: avg(nvl(vsize(rec.event_code),0))
265: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))
266: ,avg(nvl(vsize(rec.event_id),0))
267: FROM
268: hri_edw_event_hrchys rec
269: WHERE rec.level_number = 1
270: AND rec.hierarchy = 'Recruitment'
271: AND rec.last_update_date BETWEEN p_from_date AND p_to_date;
272:

Line 279: hri_edw_event_hrchys rec

275: avg(nvl(vsize(rec.event_code),0))
276: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))
277: ,avg(nvl(vsize(rec.event_id),0))
278: FROM
279: hri_edw_event_hrchys rec
280: WHERE rec.level_number = 2
281: AND rec.hierarchy = 'Recruitment'
282: AND rec.last_update_date BETWEEN p_from_date AND p_to_date;
283:

Line 290: hri_edw_event_hrchys rec

286: avg(nvl(vsize(rec.event_code),0))
287: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))
288: ,avg(nvl(vsize(rec.event_id),0))
289: FROM
290: hri_edw_event_hrchys rec
291: WHERE rec.level_number = 3
292: AND rec.hierarchy = 'Recruitment'
293: AND rec.last_update_date BETWEEN p_from_date AND p_to_date;
294:

Line 303: hri_edw_event_hrchys spn

299: avg(nvl(vsize(spn.event_code),0))
300: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))
301: ,avg(nvl(vsize(spn.event_id),0))
302: FROM
303: hri_edw_event_hrchys spn
304: WHERE spn.level_number = 1
305: AND spn.hierarchy = 'Separations'
306: AND spn.last_update_date BETWEEN p_from_date AND p_to_date;
307:

Line 314: hri_edw_event_hrchys spn

310: avg(nvl(vsize(spn.event_code),0))
311: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))
312: ,avg(nvl(vsize(spn.event_id),0))
313: FROM
314: hri_edw_event_hrchys spn
315: WHERE spn.level_number = 2
316: AND spn.hierarchy = 'Separations'
317: AND spn.last_update_date BETWEEN p_from_date AND p_to_date;
318:

Line 325: hri_edw_event_hrchys spn

321: avg(nvl(vsize(spn.event_code),0))
322: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))
323: ,avg(nvl(vsize(spn.event_id),0))
324: FROM
325: hri_edw_event_hrchys spn
326: WHERE spn.level_number = 3
327: AND spn.hierarchy = 'Separations'
328: AND spn.last_update_date BETWEEN p_from_date AND p_to_date;
329: