APPS.IGS_EN_VAL_SUSA dependencies on IGS_EN_UNIT_SET_CAT

Line 1157: v_rank IGS_EN_UNIT_SET_CAT.rank%TYPE;

1153: -- unit set. Also, check that the primary indicator is only set for
1154: -- non-administrative files.
1155: DECLARE
1156:
1157: v_rank IGS_EN_UNIT_SET_CAT.rank%TYPE;
1158: v_administrative_ind IGS_EN_UNIT_SET.administrative_ind%TYPE;
1159: v_dummy VARCHAR2(1);
1160:
1161: CURSOR c_us_usc IS

Line 1165: IGS_EN_UNIT_SET_CAT usc

1161: CURSOR c_us_usc IS
1162: SELECT us.administrative_ind,
1163: usc.rank
1164: FROM IGS_EN_UNIT_SET us,
1165: IGS_EN_UNIT_SET_CAT usc
1166: WHERE us.unit_set_cd = p_unit_set_cd AND
1167: us.version_number = p_us_version_number AND
1168: us.unit_set_cat = usc.unit_set_cat;
1169: CURSOR c_susa_us_usc (

Line 1170: cp_rank IGS_EN_UNIT_SET_CAT.rank%TYPE) IS

1166: WHERE us.unit_set_cd = p_unit_set_cd AND
1167: us.version_number = p_us_version_number AND
1168: us.unit_set_cat = usc.unit_set_cat;
1169: CURSOR c_susa_us_usc (
1170: cp_rank IGS_EN_UNIT_SET_CAT.rank%TYPE) IS
1171: SELECT 'x'
1172: FROM IGS_AS_SU_SETATMPT susa,
1173: IGS_EN_UNIT_SET us,
1174: IGS_EN_UNIT_SET_CAT usc

Line 1174: IGS_EN_UNIT_SET_CAT usc

1170: cp_rank IGS_EN_UNIT_SET_CAT.rank%TYPE) IS
1171: SELECT 'x'
1172: FROM IGS_AS_SU_SETATMPT susa,
1173: IGS_EN_UNIT_SET us,
1174: IGS_EN_UNIT_SET_CAT usc
1175: WHERE susa.person_id = p_person_id AND
1176: susa.course_cd = p_course_cd AND
1177: susa.unit_set_cd = us.unit_set_cd AND
1178: susa.us_version_number = us.version_number AND