APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PS_VER

Line 17: g_ps_ver igs_ps_ver%ROWTYPE;

13: g_he_st_spa igs_he_st_spa%ROWTYPE;
14: g_as_su_setatmpt igs_as_su_setatmpt%ROWTYPE;
15: g_he_en_susa igs_he_en_susa%ROWTYPE;
16: g_he_st_prog igs_he_st_prog%ROWTYPE;
17: g_ps_ver igs_ps_ver%ROWTYPE;
18: g_he_poous igs_he_poous%ROWTYPE;
19: g_pe_person igs_pe_person%ROWTYPE;
20: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;
21:

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:

Line 1199: FROM igs_ps_ver crv,

1195: hpud.location_of_study,
1196: hpud.credit_value_yop1,
1197: hpud.fte_intensity ,
1198: hpud.funding_source
1199: FROM igs_ps_ver crv,
1200: igs_he_st_prog hpr,
1201: igs_he_poous hpud
1202: WHERE crv.course_cd = hpr.course_cd
1203: AND crv.version_number = hpr.version_number