APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PS_VER_ALL

Line 108: FROM igs_ps_ver_all

104: -- Only to be run if prog type award conferral dates exist for submission
105: -- i.e. g_prog_type_rec_flag is TRUE
106: CURSOR c_prog_type IS
107: SELECT course_type
108: FROM igs_ps_ver_all
109: WHERE course_cd = g_en_stdnt_ps_att.course_cd
110: AND version_number = g_en_stdnt_ps_att.version_number;
111:
112: l_prog_type igs_ps_ver_all.course_type%TYPE;

Line 112: l_prog_type igs_ps_ver_all.course_type%TYPE;

108: FROM igs_ps_ver_all
109: WHERE course_cd = g_en_stdnt_ps_att.course_cd
110: AND version_number = g_en_stdnt_ps_att.version_number;
111:
112: l_prog_type igs_ps_ver_all.course_type%TYPE;
113: l_awd_conf_start_dt igs_he_submsn_awd.award_start_date%TYPE;
114: l_awd_conf_end_dt igs_he_submsn_awd.award_end_date%TYPE;
115: l_valid BOOLEAN;
116: