APPS.IGS_AD_VAL_ACAI dependencies on IGS_PS_VER

Line 616: FROM IGS_PS_VER

612: -- and against the course offering option.
613: DECLARE
614: CURSOR c_crv IS
615: SELECT version_number
616: FROM IGS_PS_VER
617: WHERE course_cd = p_course_cd;
618: v_crv_rec c_crv%ROWTYPE;
619: cst_error CONSTANT VARCHAR2(1) := 'E';
620: cst_warn CONSTANT VARCHAR2(1) := 'W';

Line 642: -- Restrict the IGS_PS_VER records to match

638: p_return_type := cst_error;
639: RETURN FALSE;
640: END IF;
641: FOR v_crv_rec IN c_crv LOOP
642: -- Restrict the IGS_PS_VER records to match
643: -- on input parameters.
644: IF p_version_number IS NULL OR
645: p_version_number = v_crv_rec.version_number THEN
646: v_message_name := NULL;

Line 3522: FROM IGS_PS_VER crv,

3518: WHERE scae.person_id = p_person_id AND
3519: scae.course_cd = p_course_cd;
3520: CURSOR c_crv IS
3521: SELECT 'x'
3522: FROM IGS_PS_VER crv,
3523: IGS_PS_TYPE cty
3524: WHERE crv.course_cd = p_course_cd AND
3525: crv.version_number = p_crv_version_number AND
3526: cty.course_type = crv.course_type AND