APPS.EDW_HR_POSITION_M_SIZING dependencies on HR_GENERAL

Line 83: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY',frequency)),0))

79: ,avg(nvl(vsize(replacement_required_flag),0))
80: ,avg(nvl(vsize(time_normal_start),0))
81: ,avg(nvl(vsize(time_normal_finish),0))
82: ,avg(nvl(vsize(working_hours),0))
83: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY',frequency)),0))
84: FROM per_all_positions
85: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
86:
87: CURSOR bgr_cur IS