APPS.EDW_HR_REC_ACT_M_SIZING dependencies on HR_LOOKUPS

Line 95: FROM hr_lookups

91:
92: CURSOR hrl_cur IS
93: SELECT avg(nvl(vsize(lookup_code),0))
94: ,avg(nvl(vsize(meaning),0))
95: FROM hr_lookups
96: WHERE last_update_date BETWEEN p_from_date AND p_to_date
97: AND lookup_type = 'REC_TYPE';
98:
99: