DBA Data[Home] [Help]

APPS.IGS_PT_GEN_PKG dependencies on IGS_PS_VER_ALL

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: