APPS.IGS_AS_GEN_003 dependencies on IGS_PS_UNIT_VER

Line 754: FROM IGS_PS_UNIT_VER

750: UAI.CAL_TYPE, UAI.CI_SEQUENCE_NUMBER, 'N') = 'Y';
751: v_unit_cd IGS_CA_INST_REL.sup_cal_type%TYPE;
752: CURSOR c_uv IS
753: SELECT supp_exam_permitted_ind
754: FROM IGS_PS_UNIT_VER
755: WHERE unit_cd = p_unit_cd AND
756: version_number = p_version_number;
757: v_supp_exam_permitted_ind IGS_PS_UNIT_VER.supp_exam_permitted_ind%TYPE;
758: rec_uoo_id cur_uoo_id%ROWTYPE;

Line 757: v_supp_exam_permitted_ind IGS_PS_UNIT_VER.supp_exam_permitted_ind%TYPE;

753: SELECT supp_exam_permitted_ind
754: FROM IGS_PS_UNIT_VER
755: WHERE unit_cd = p_unit_cd AND
756: version_number = p_version_number;
757: v_supp_exam_permitted_ind IGS_PS_UNIT_VER.supp_exam_permitted_ind%TYPE;
758: rec_uoo_id cur_uoo_id%ROWTYPE;
759: BEGIN
760: -- anilk, 22-Apr-2003, Bug# 2829262
761: OPEN cur_uoo_id;

Line 776: -- If supps are not permitted for the IGS_PS_UNIT version then return 'N', indicating

772: -- anilk, 22-Apr-2003, Bug# 2829262
773: rec_uoo_id.uoo_id) NOT IN ('SUPP','SPECIAL') THEN
774: RETURN 'NA';
775: END IF;
776: -- If supps are not permitted for the IGS_PS_UNIT version then return 'N', indicating
777: -- the exam is not permitted.
778: OPEN c_uv;
779: FETCH c_uv INTO v_supp_exam_permitted_ind;
780: CLOSE c_uv;