DBA Data[Home] [Help]

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: