DBA Data[Home] [Help]

APPS.WIP_PREFERENCES_PKG dependencies on DUAL

Line 48: from dual;

44: and nvl(l.resp_key,'NULL') = nvl(cl_resp_key, 'NULL')
45: and nvl(l.organization_id, -99) = nvl(cl_org_id, -99)
46: and nvl(l.department_id, -99) = nvl(cl_dept_id, -99)),
47: 'INHERIT') AS single_value_code
48: from dual;
49: cursor multi_value (cl_resp_key VARCHAR2,
50: cl_org_id NUMBER,
51: cl_dept_id NUMBER) is
52: select count(v.attribute_value_code) as multi_value_count