APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_PS_VER_ALL

Line 9533: igs_ps_ver_all psv,

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

Line 9692: cp_crv_version_number igs_ps_ver_all.version_number%TYPE ) IS

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,