APPS.EDW_HR_PRSN_TYP_M_SIZING dependencies on HR_GENERAL
Line 107: avg(nvl(vsize(hr_general.decode_lookup('YES_NO','Y')),0))
103: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
104:
105: CURSOR yes_no_cur IS
106: SELECT 107: avg(nvl(vsize(hr_general.decode_lookup('YES_NO','Y')),0)) 108: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO','N')),0))
109: FROM dual;
110:
111: BEGIN
Line 108: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO','N')),0))
104:
105: CURSOR yes_no_cur IS
106: SELECT
107: avg(nvl(vsize(hr_general.decode_lookup('YES_NO','Y')),0)) 108: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO','N')),0)) 109: FROM dual;
110:
111: BEGIN
112: