APPS.IGS_PS_VAL_POSU dependencies on IGS_PS_UNIT_OFR_OPT

Line 233: IGS_PS_UNIT_OFR_OPT uoo,

229: v_dummy VARCHAR2(1);
230: CURSOR c_posp_uoo_ci IS
231: SELECT 'X'
232: FROM IGS_PS_PAT_STUDY_PRD posp,
233: IGS_PS_UNIT_OFR_OPT uoo,
234: IGS_CA_INST ci
235: WHERE posp.course_cd = p_course_cd AND
236: posp.version_number = p_version_number AND
237: posp.cal_type = p_cal_type AND

Line 260: -- 2. Check for future IGS_PS_UNIT_OFR_OPT records for the IGS_PS_COURSE offering

256: p_unit_cd IS NULL) THEN
257: p_message_name := NULL;
258: RETURN TRUE;
259: END IF;
260: -- 2. Check for future IGS_PS_UNIT_OFR_OPT records for the IGS_PS_COURSE offering
261: -- supplied for the IGS_PS_PAT_STUDY_UNT.unit_cd, location_cd, IGS_AS_UNIT_CLASS
262: -- and IGS_PS_PAT_STUDY_PRD.teach_cal_type
263: OPEN c_posp_uoo_ci;
264: FETCH c_posp_uoo_ci INTO v_dummy;