APPS.IGS_EN_VAL_SUSA dependencies on IGS_PS_OFR_UNIT_SET

Line 245: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;

241: DECLARE
242: v_ver_no IGS_EN_STDNT_PS_ATT.version_number%TYPE;
243: v_susa_us_version_no IGS_AS_SU_SETATMPT.us_version_number%TYPE;
244: v_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE;
245: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;
246: v_check VARCHAR2(1) := NULL;
247: -- Determine if the student's course offering and the course version
248: CURSOR c_sca IS
249: SELECT sca.version_number,

Line 816: FROM IGS_PS_OFR_UNIT_SET cous,

812:
813:
814: CURSOR c_uso IS
815: SELECT 'X'
816: FROM IGS_PS_OFR_UNIT_SET cous,
817: igs_en_unit_set_stat uss1,
818: IGS_EN_UNIT_SET_ALL US,
819: IGS_EN_STDNT_PS_ATT spa
820: WHERE spa.person_id = p_person_id