APPS.IGS_PS_VAL_COUSR dependencies on IGS_PS_COO_AD_UNIT_S

Line 235: v_unit_set_cd IGS_PS_COO_AD_UNIT_S.unit_set_cd%TYPE;

231: -- validate that a crs_off_set_relationship record can't be created
232: -- with a IGS_PS_OFR_UNIT_SET as the subordinate when the IGS_PS_UNIT set is
233: -- restricting an IGS_PS_COURSE offering option admission category
234: DECLARE
235: v_unit_set_cd IGS_PS_COO_AD_UNIT_S.unit_set_cd%TYPE;
236: CURSOR c_cacus IS
237: SELECT cacus.unit_set_cd
238: FROM IGS_PS_COO_AD_UNIT_S cacus
239: WHERE cacus.course_cd = p_course_cd AND

Line 238: FROM IGS_PS_COO_AD_UNIT_S cacus

234: DECLARE
235: v_unit_set_cd IGS_PS_COO_AD_UNIT_S.unit_set_cd%TYPE;
236: CURSOR c_cacus IS
237: SELECT cacus.unit_set_cd
238: FROM IGS_PS_COO_AD_UNIT_S cacus
239: WHERE cacus.course_cd = p_course_cd AND
240: cacus.crv_version_number = p_crv_version_number AND
241: cacus.cal_type = p_cal_type AND
242: cacus.unit_set_cd = p_sub_unit_set_cd AND