APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_POOUS

Line 20: g_he_poous igs_he_poous%ROWTYPE;

16: g_he_st_prog igs_he_st_prog%ROWTYPE;
17: g_ps_ver igs_ps_ver%ROWTYPE;
18: g_ps_type igs_ps_type_all%ROWTYPE;
19: g_ps_ofr_opt igs_ps_ofr_opt%ROWTYPE;
20: g_he_poous igs_he_poous%ROWTYPE;
21: g_pe_person igs_pe_person%ROWTYPE;
22: g_pe_stat_v igs_pe_stat_v%ROWTYPE;
23: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;
24: g_he_st_unt_vs igs_he_st_unt_vs%ROWTYPE;

Line 117: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS

113: AND NVL(b.closed_ind,'N') = 'N' )
114: ORDER BY a.year DESC;
115:
116: -- get the govt field of study for the subject
117: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS
118: SELECT govt_field_of_study
119: FROM IGS_PS_FLD_OF_STUDY PFS
120: WHERE field_of_study = p_subject;
121:

Line 9684: -- smaddali modified this cursor to select funding_source field from igs_he_poous for hefd208 - bug#2717751

9680: )
9681: )
9682: ORDER BY susa.rqrmnts_complete_dt DESC, susa.end_dt DESC, susa.selection_dt DESC;
9683:
9684: -- smaddali modified this cursor to select funding_source field from igs_he_poous for hefd208 - bug#2717751
9685: -- smaddali added version_number parameter for HECR214 build, we need to get the Term record program version details
9686: CURSOR c_crse (p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,

Line 9690: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,

9686: CURSOR c_crse (p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
9689: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
9690: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
9691: p_us_version_number igs_he_poous_all.us_version_number%TYPE,
9692: cp_crv_version_number igs_ps_ver_all.version_number%TYPE ) IS
9693: SELECT crv.title,
9694: crv.std_annual_load,

Line 9691: p_us_version_number igs_he_poous_all.us_version_number%TYPE,

9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
9689: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
9690: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
9691: p_us_version_number igs_he_poous_all.us_version_number%TYPE,
9692: cp_crv_version_number igs_ps_ver_all.version_number%TYPE ) IS
9693: SELECT crv.title,
9694: crv.std_annual_load,
9695: pop.program_length,

Line 9752: igs_he_poous hpud,

9748: hpud.level_applicable_to_funding,
9749: hpud.funding_source
9750: FROM igs_ps_ver crv,
9751: igs_he_st_prog hpr,
9752: igs_he_poous hpud,
9753: igs_ps_ofr_opt pop
9754: WHERE crv.course_cd = hpr.course_cd
9755: AND crv.version_number = hpr.version_number
9756: AND crv.course_cd = p_course_cd

Line 10187: -- smaddali modified this cursor to select funding_source field from igs_he_poous for hefd208 - bug#2717751

10183: g_en_stdnt_ps_att.location_cd,
10184: g_as_su_setatmpt.unit_set_cd,
10185: g_as_su_setatmpt.us_version_number,
10186: g_en_stdnt_ps_att.version_number);
10187: -- smaddali modified this cursor to select funding_source field from igs_he_poous for hefd208 - bug#2717751
10188: FETCH c_crse INTO g_ps_ver.title,
10189: g_ps_ver.std_annual_load,
10190: g_ps_ofr_opt.program_length,
10191: g_ps_ofr_opt.program_length_measurement,