APPS.IGS_AS_SUAO_LGCY_PUB dependencies on IGS_AS_GRD_SCHEMA

Line 722: 1 and 999 and should have a valid setup in table igs_as_grd_schema

718: gen_log_info('Start of validate_parameters.Validation 9');
719:
720: /*
721: 1. If an incomplete grading schema code is not null then the incomplete grading schema version number should be between
722: 1 and 999 and should have a valid setup in table igs_as_grd_schema
723: 2. ELSE if a incomp version number is not null then the incomp grading schema also needs to be not null
724: */
725:
726: DECLARE

Line 733: igs_as_grd_schema

729: IS
730: SELECT
731: 'X'
732: FROM
733: igs_as_grd_schema
734: WHERE
735: grading_schema_cd = p_lgcy_suo_rec.incomp_grading_schema_cd AND
736: version_number = p_lgcy_suo_rec.incomp_version_number;
737:

Line 751: table igs_as_grd_schema.

747: END IF;
748:
749: /*
750: check if a valid value for both incomplete grading schema and incomplete grading schema version number exists in the set up
751: table igs_as_grd_schema.
752: IF not then raise an error message.
753: */
754: OPEN cur_incomp_grd_sch_exists;
755: FETCH cur_incomp_grd_sch_exists INTO l_exists;