APPS.IGS_AV_GEN_001 dependencies on IGS_AS_GRD_SCH_GRADE

Line 347: FROM igs_as_grd_sch_grade

343:
344: CURSOR c_validate_grade_cur(grschcd VARCHAR2,grschvno NUMBER,grd VARCHAR2)
345: IS
346: SELECT COUNT (rowid)
347: FROM igs_as_grd_sch_grade
348: WHERE grading_schema_cd = grschcd
349: AND version_number = grschvno
350: AND grade = grd;
351:

Line 1425: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1421: gv_other_detail VARCHAR2(255);
1422: gv_s_result_type VARCHAR2(10);
1423: v_sua_rec_found BOOLEAN;
1424: v_sub_sua_recs_found BOOLEAN;
1425: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1426: gv_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;

Line 1426: gv_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1422: gv_s_result_type VARCHAR2(10);
1423: v_sua_rec_found BOOLEAN;
1424: v_sub_sua_recs_found BOOLEAN;
1425: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1426: gv_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;

Line 1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1423: v_sua_rec_found BOOLEAN;
1424: v_sub_sua_recs_found BOOLEAN;
1425: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1426: gv_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;