[Home] [Help]
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_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;
9529: hspa.franch_partner_cd,
9530: pst.course_type
9531: FROM igs_en_stdnt_ps_att_all sca,
9532: igs_he_st_spa_all hspa,
9533: igs_ps_ver_all psv,
9534: igs_ps_type_all pst
9535: WHERE sca.person_id = p_person_id
9536: AND sca.course_cd = p_course_cd
9537: AND sca.version_number = p_crv_version_number
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,
9696: pop.program_length_measurement,
9746: hpud.fundability_cd,
9747: hpud.fee_band,
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