APPS.IGS_AS_NOTIFY_STUDENT dependencies on FND_USER

Line 114: FROM fnd_user

110: -- cursor to get the user_name corresponding to the person_id
111:
112: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
113: SELECT user_name
114: FROM fnd_user
115: WHERE person_party_id = cp_person_id;
116:
117: l_user_name fnd_user.user_name%TYPE;
118:

Line 117: l_user_name fnd_user.user_name%TYPE;

113: SELECT user_name
114: FROM fnd_user
115: WHERE person_party_id = cp_person_id;
116:
117: l_user_name fnd_user.user_name%TYPE;
118:
119: CURSOR c_dup_user (cp_user_name VARCHAR2,
120: cp_role_name VARCHAR2) IS
121: SELECT count(1)

Line 326: FROM fnd_user

322: -- Getting the user name to whom the notification to be send
323:
324: CURSOR c_user_name IS
325: SELECT user_name
326: FROM fnd_user
327: WHERE person_party_id = p_instructor;
328:
329: -- Getting the logged in User
330:

Line 333: FROM fnd_user

329: -- Getting the logged in User
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;

Line 337: l_cur_from_user fnd_user.user_name%TYPE;

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;
339:
340: BEGIN
341:

Line 338: l_c_user_name fnd_user.user_name%TYPE;

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;
339:
340: BEGIN
341:
342: -- Checking if the Workflow is installed at the environment or not.

Line 456: FROM fnd_user

452: -- cursor to get the user_name corresponding to the person_id
453:
454: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
455: SELECT user_name
456: FROM fnd_user
457: WHERE person_party_id = cp_person_id;
458:
459: l_user_name fnd_user.user_name%TYPE;
460:

Line 459: l_user_name fnd_user.user_name%TYPE;

455: SELECT user_name
456: FROM fnd_user
457: WHERE person_party_id = cp_person_id;
458:
459: l_user_name fnd_user.user_name%TYPE;
460:
461: CURSOR c_dup_user (cp_user_name VARCHAR2,
462: cp_role_name VARCHAR2) IS
463: SELECT count(1)