APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_REF_CD

Line 373: FROM IGS_PS_REF_CD

369: WHERE course_cd = p_course_cd AND
370: version_number = p_version_number;
371: CURSOR c_get_reference_cd_type IS
372: SELECT reference_cd_type
373: FROM IGS_PS_REF_CD
374: WHERE course_cd = p_course_cd AND
375: version_number = p_version_number;
376: CURSOR c_get_course_group_cd IS
377: SELECT course_group_cd

Line 547: -- Validate the IGS_PS_REF_CD table and that

543: END LOOP;
544: IF (v_terminate = TRUE) THEN
545: RETURN FALSE;
546: END IF;
547: -- Validate the IGS_PS_REF_CD table and that
548: -- IGS_GE_REF_CD_TYPE is not closed
549: FOR crc_rec IN c_get_reference_cd_type LOOP
550: IF (IGS_PS_VAL_CRFC.crsp_val_ref_cd_type(
551: crc_rec.reference_cd_type,