APPS.IGS_AS_NOTIFY_STUDENT dependencies on DUAL

Line 34: dual;

30: IS
31: SELECT
32: igs_as_wf_beas006_s.NEXTVAL
33: FROM
34: dual;
35:
36:
37:
38: BEGIN

Line 313: FROM dual;

309: -- Gets a unique sequence number
310:
311: CURSOR c_seq_num IS
312: SELECT igs_as_reldate_s.NEXTVAL
313: FROM dual;
314:
315:
316: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
317:

Line 320: FROM dual;

316: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
317:
318: CURSOR cur_prof_value IS
319: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
320: FROM dual;
321:
322: -- Getting the user name to whom the notification to be send
323:
324: CURSOR c_user_name IS

Line 334: WHERE user_id = (SELECT FND_GLOBAL.USER_ID user_id FROM dual);

330:
331: CURSOR cur_from_user IS
332: SELECT user_name
333: FROM fnd_user
334: WHERE user_id = (SELECT FND_GLOBAL.USER_ID user_id FROM dual);
335:
336: l_cur_prof_value cur_prof_value%ROWTYPE;
337: l_cur_from_user fnd_user.user_name%TYPE;
338: l_c_user_name fnd_user.user_name%TYPE;