APPS.IGS_PR_PROG_OUT_WF_PKG dependencies on IGS_PS_VER

Line 43: CURSOR c_program_title (cp_course_cd igs_ps_ver.course_cd%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
45: FROM igs_ps_ver
46: WHERE course_cd = cp_course_cd ;
47:

Line 45: FROM igs_ps_ver

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

Line 51: l_title igs_ps_ver.title%TYPE ;

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:
55: BEGIN

Line 52: l_course_cd igs_ps_ver.course_cd%TYPE ;

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:
55: BEGIN
56: