APPS.ITG_SYNCEXCHINBOUND_PVT dependencies on DUAL

Line 17: FROM DUAL

13: l_number NUMBER;
14: BEGIN
15: SELECT 1
16: INTO l_number
17: FROM DUAL
18: WHERE EXISTS (SELECT t.conversion_type
19: from gl_daily_conversion_types_v t
20: where t.conversion_type <> 'User'
21: and t.conversion_type <> 'EMU FIXED'

Line 159: select to_number(p_factor) into l_var from dual;

155: l_param_name := 'SYNCIND';
156: l_param_value := p_syncind;
157: ELSIF p_factor IS NOT NULL THEN
158: BEGIN
159: select to_number(p_factor) into l_var from dual;
160: EXCEPTION
161: WHEN OTHERS THEN
162: l_param_name := 'FACTOR';
163: l_param_value := p_factor;