APPS.IGS_PR_PROG_OUT_WF_PKG dependencies on FND_USER

Line 35: FROM fnd_user

31: -- cursor to get the user_name corresponding to the person_id
32:
33: CURSOR c_user_name (cp_person_id igs_pe_person.person_id%TYPE) IS
34: SELECT user_name
35: FROM fnd_user
36: WHERE person_party_id = cp_person_id;
37:
38: CURSOR c_student_info (cp_person_id igs_pe_person.person_id%TYPE) IS
39: SELECT person_pre_name_adjunct,party_name

Line 48: l_user_name fnd_user.user_name%TYPE;

44: SELECT title
45: FROM igs_ps_ver
46: WHERE course_cd = cp_course_cd ;
47:
48: l_user_name fnd_user.user_name%TYPE;
49: l_person_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE;
50: l_party_name hz_parties.party_name%TYPE;
51: l_title igs_ps_ver.title%TYPE ;
52: l_course_cd igs_ps_ver.course_cd%TYPE ;