APPS.CSI_CTR_GEN_UTILITY_PVT dependencies on DUAL

Line 58: WHERE audsid = (SELECT userenv('SESSIONID') FROM dual);

54: IF g_sid is NULL THEN
55: SELECT sid, osuser
56: INTO l_sid, l_os_user
57: FROM v$session
58: WHERE audsid = (SELECT userenv('SESSIONID') FROM dual);
59: --
60: g_sid := l_sid;
61: g_osuser := l_os_user;
62: END IF;

Line 69: FROM dual;

65:
66: BEGIN
67: SELECT instr(g_debug_file,'.')
68: INTO l_instr
69: FROM dual;
70: EXCEPTION
71: WHEN OTHERS THEN
72: l_instr := 0;
73: END;

Line 81: FROM dual;

77: ELSE
78: BEGIN
79: SELECT substr(g_debug_file,1,l_instr-1)||'-counter'||substr(g_debug_file,l_instr)
80: INTO l_log_file
81: FROM dual;
82: EXCEPTION
83: WHEN OTHERS THEN
84: null;
85: END;

Line 706: l_formula := 'SELECT '||l_formula||' FROM DUAL';

702: --Start Process
703: BEGIN
704: --Open the cursor
705: l_cursor_handle := dbms_sql.open_cursor;
706: l_formula := 'SELECT '||l_formula||' FROM DUAL';
707:
708: -- parse the formula using dual table
709: -- if formula is :a/2, in a sql statement it will become 'select :a/2 from dual'
710:

Line 708: -- parse the formula using dual table

704: --Open the cursor
705: l_cursor_handle := dbms_sql.open_cursor;
706: l_formula := 'SELECT '||l_formula||' FROM DUAL';
707:
708: -- parse the formula using dual table
709: -- if formula is :a/2, in a sql statement it will become 'select :a/2 from dual'
710:
711: DBMS_SQL.PARSE(l_cursor_handle, l_formula, dbms_sql.native);
712:

Line 709: -- if formula is :a/2, in a sql statement it will become 'select :a/2 from dual'

705: l_cursor_handle := dbms_sql.open_cursor;
706: l_formula := 'SELECT '||l_formula||' FROM DUAL';
707:
708: -- parse the formula using dual table
709: -- if formula is :a/2, in a sql statement it will become 'select :a/2 from dual'
710:
711: DBMS_SQL.PARSE(l_cursor_handle, l_formula, dbms_sql.native);
712:
713: --define column to select value