APPS.MSC_ASK_ORACLE dependencies on DUAL

Line 39: FROM dual;

35: -- Note that the sequence will ensure that all question_ids are
36: -- greater than 5001
37: SELECT msc_questions_s.nextval
38: INTO x_question_id
39: FROM dual;
40: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
41:
42: INSERT INTO MSC_QUESTIONS_B(
43: QUESTION_ID

Line 64: FROM dual

60: ,fnd_global.user_id
61: ,sysdate
62: ,fnd_global.user_id
63: ,fnd_global.conc_login_id
64: FROM dual
65: WHERE not exists (select 'already exists'
66: from msc_questions_b
67: where question_code = x_question_code);
68: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);

Line 94: FROM dual

90: ,fnd_global.user_id
91: ,sysdate
92: ,fnd_global.user_id
93: ,fnd_global.conc_login_id
94: FROM dual
95: WHERE not exists
96: (select 'already exists'
97: from msc_questions_tl
98: where question_id = (select question_id

Line 107: FROM dual;

103: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));
104: ELSIF (x_mode = 2) THEN -- copy mode
105: SELECT msc_questions_s.nextval
106: INTO x_question_id
107: FROM dual;
108: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
109:
110: INSERT INTO MSC_QUESTIONS_B(
111: QUESTION_ID

Line 319: FROM sys.dual;

315: IS
316: BEGIN
317: SELECT msc_answers_s.nextval
318: INTO answer_id
319: FROM sys.dual;
320:
321: return;
322: EXCEPTION
323: WHEN OTHERS THEN

Line 367: FROM sys.dual;

363: sysdate,
364: FND_GLOBAL.USER_ID,
365: sysdate,
366: FND_GLOBAL.USER_ID
367: FROM sys.dual;
368:
369: return;
370: EXCEPTION
371: WHEN OTHERS THEN