APPS.IGS_AS_NOTIFY_STUDENT dependencies on IGS_AS_ORD_ITM_INT

Line 112: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

108: l_person_id VARCHAR2(30);
109:
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:

Line 454: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

450: l_person_id VARCHAR2(30);
451:
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: