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.

[Home] [Help]

APPS.EDW_HR_REASON_M_SIZING dependencies on HR_LOOKUPS

Line 15: FROM hr_lookups hrl

11:
12: /* Cursor description */
13: CURSOR row_count_cur IS
14: SELECT count(hrl.meaning) total
15: FROM hr_lookups hrl
16: ,(select evt.reason_type from hri_edw_event_hrchys evt
17: where not exists (select 1 from hri_edw_event_hrchys dummy
18: where dummy.rowid > evt.rowid
19: and evt.reason_type = dummy.reason_type)) types

Line 69: FROM hr_lookups hrl

65: avg(nvl(vsize(hrl.meaning),0))
66: ,avg(nvl(vsize(hrl.meaning),0))
67: ,avg(nvl(vsize(hrl.lookup_type),0))
68: ,avg(nvl(vsize(hrl.lookup_code),0))
69: FROM hr_lookups hrl
70: ,(select evt.reason_type from hri_edw_event_hrchys evt
71: where not exists (select 1 from hri_edw_event_hrchys dummy
72: where dummy.rowid > evt.rowid
73: and evt.reason_type = dummy.reason_type)) types