APPS.IGS_PS_VAL_POSU dependencies on IGS_PS_PAT_STUDY_PRD

Line 232: FROM IGS_PS_PAT_STUDY_PRD posp,

228: DECLARE
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

Line 262: -- and IGS_PS_PAT_STUDY_PRD.teach_cal_type

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;
265: IF (c_posp_uoo_ci%NOTFOUND) THEN
266: CLOSE c_posp_uoo_ci;