APPS.IGS_PT_GEN_PKG dependencies on IGS_PS_VER

Line 89: CURSOR c_career(p_prog_cd igs_ps_ver_all.course_cd%TYPE,p_ver_num igs_ps_ver_all.version_number%TYPE) IS

85: WHERE COURSE_CD = p_prog_cd
86: AND PERSON_ID = p_person_id
87: ORDER BY commencement_dt DESC;
88:
89: CURSOR c_career(p_prog_cd igs_ps_ver_all.course_cd%TYPE,p_ver_num igs_ps_ver_all.version_number%TYPE) IS
90: SELECT course_type
91: FROM igs_ps_ver_all
92: WHERE course_cd = p_prog_cd
93: AND version_number = p_ver_num ;

Line 91: FROM igs_ps_ver_all

87: ORDER BY commencement_dt DESC;
88:
89: CURSOR c_career(p_prog_cd igs_ps_ver_all.course_cd%TYPE,p_ver_num igs_ps_ver_all.version_number%TYPE) IS
90: SELECT course_type
91: FROM igs_ps_ver_all
92: WHERE course_cd = p_prog_cd
93: AND version_number = p_ver_num ;
94:
95:

Line 107: p_career igs_ps_ver.course_type%TYPE;

103: l_programlist VARCHAR2(2000);
104:
105: p_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
106: p_program_ver igs_en_stdnt_ps_att_all.version_number%TYPE;
107: p_career igs_ps_ver.course_type%TYPE;
108: p_program_list VARCHAR2(2000);
109: p_program_title VARCHAR2(200);
110: l_curr_prog_cd_tmp igs_en_stdnt_ps_att_all.course_cd%TYPE;
111: