APPS.EDW_HR_REASON_M_SIZING dependencies on HRI_EDW_EVENT_HRCHYS

Line 16: ,(select evt.reason_type from hri_edw_event_hrchys evt

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
20: WHERE NVL(hrl.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))

Line 17: where not exists (select 1 from hri_edw_event_hrchys dummy

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
20: WHERE NVL(hrl.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
21: BETWEEN p_from_date AND p_to_date

Line 70: ,(select evt.reason_type from hri_edw_event_hrchys evt

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
74: WHERE NVL(hrl.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))

Line 71: where not exists (select 1 from hri_edw_event_hrchys dummy

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
74: WHERE NVL(hrl.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
75: BETWEEN p_from_date AND p_to_date