APPS.IGS_PR_PROG_OUT_WF_PKG dependencies on HZ_PARTIES

Line 40: FROM hz_parties

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:
43: CURSOR c_program_title (cp_course_cd igs_ps_ver.course_cd%TYPE) IS
44: SELECT title

Line 49: l_person_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE;

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 ;
53:

Line 50: l_party_name hz_parties.party_name%TYPE;

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 ;
53:
54: