APPS.IGS_AS_SUAO_LGCY_PUB dependencies on IGS_AS_GRD_SCH_TRN

Line 1370: igs_as_grd_sch_trn gsgt

1366: IS
1367: SELECT
1368: gsgt.to_grade
1369: FROM
1370: igs_as_grd_sch_trn gsgt
1371: WHERE
1372: gsgt.grading_schema_cd = p_lgcy_suo_rec.grading_schema_cd
1373: AND gsgt.version_number = p_lgcy_suo_rec.version_number
1374: AND gsgt.grade = p_lgcy_suo_rec.grade

Line 1379: l_grade IGS_AS_GRD_SCH_TRN.TO_GRADE%TYPE ;

1375: AND gsgt.to_grading_schema_cd = cp_grading_schema_cd
1376: AND gsgt.to_version_number = cp_gs_ver_num;
1377:
1378: rec_cur_cop CUR_COP%ROWTYPE ;
1379: l_grade IGS_AS_GRD_SCH_TRN.TO_GRADE%TYPE ;
1380: l_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE ;
1381: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
1382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
1383: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE ;