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 HR_GENERAL

Line 195: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))

191:
192: CURSOR gain1_cur IS
193: SELECT
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

Line 206: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))

202:
203: CURSOR gain2_cur IS
204: SELECT
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

Line 217: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))

213:
214: CURSOR gain3_cur IS
215: SELECT
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

Line 230: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))

226:
227: CURSOR loss1_cur IS
228: SELECT
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

Line 241: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))

237:
238: CURSOR loss2_cur IS
239: SELECT
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

Line 252: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))

248:
249: CURSOR loss3_cur IS
250: SELECT
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

Line 265: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))

261:
262: CURSOR rec1_cur IS
263: SELECT
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

Line 276: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))

272:
273: CURSOR rec2_cur IS
274: SELECT
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

Line 287: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))

283:
284: CURSOR rec3_cur IS
285: SELECT
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

Line 300: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))

296:
297: CURSOR spn1_cur IS
298: SELECT
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

Line 311: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))

307:
308: CURSOR spn2_cur IS
309: SELECT
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

Line 322: ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))

318:
319: CURSOR spn3_cur IS
320: SELECT
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