APPS.IGS_PR_PROG_OUT_WF_PKG dependencies on IGS_PE_PERSON

Line 33: CURSOR c_user_name (cp_person_id igs_pe_person.person_id%TYPE) IS

29:
30:
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:

Line 38: CURSOR c_student_info (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
40: FROM hz_parties
41: WHERE party_id = cp_person_id ;
42: