eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_VAL_SUA dependencies on IGS_AS_GRD_SCH_GRADE

Line 1597: IGS_AS_GRD_SCH_GRADE gsg,

1593: CURSOR c_get_schema_dtls IS
1594: SELECT DISTINCT gs.grading_schema_cd,
1595: gs.version_number
1596: FROM IGS_AS_GRD_SCHEMA gs,
1597: IGS_AS_GRD_SCH_GRADE gsg,
1598: IGS_AD_ADM_UT_STA_GD ausg
1599: WHERE gs.start_dt <= TRUNC(p_effective_dt) AND
1600: (gs.end_dt IS NULL OR
1601: gs.end_dt >= TRUNC(p_effective_dt)) AND

Line 1699: igs_as_grd_sch_grade gsg

1695: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1696: SELECT COUNT(*)
1697: FROM igs_ad_adm_ut_sta_gd ausg,
1698: igs_as_grd_schema gs,
1699: igs_as_grd_sch_grade gsg
1700: WHERE ausg.administrative_unit_status = cp_admin_unit_status AND
1701: gs.grading_schema_cd = ausg.grading_schema_cd AND
1702: gs.version_number = ausg.version_number AND
1703: TRUNC(gs.start_dt) <= TRUNC(cp_effective_dt) AND

Line 1723: igs_as_grd_sch_grade gsg

1719: ausg.version_number,
1720: ausg.grade
1721: FROM igs_ad_adm_ut_sta_gd ausg,
1722: igs_as_grd_schema gs,
1723: igs_as_grd_sch_grade gsg
1724: WHERE ausg.administrative_unit_status = cp_admin_unit_status AND
1725: gs.grading_schema_cd = ausg.grading_schema_cd AND
1726: gs.version_number = ausg.version_number AND
1727: gs.start_dt <= TRUNC(cp_effective_dt) AND

Line 1749: igs_as_grd_sch_grade gsg

1745: FROM IGS_EN_SU_ATTEMPT sua,
1746: IGS_PS_UNIT_OFR_OPT uoo,
1747: IGS_AD_ADM_UT_STA_GD ausg,
1748: IGS_AS_GRD_SCHEMA gs,
1749: igs_as_grd_sch_grade gsg
1750: WHERE sua.person_id = p_person_id AND
1751: sua.course_cd = p_course_cd AND
1752: sua.uoo_id = p_uoo_id AND
1753: sua.unit_cd = uoo.unit_cd AND

Line 3282: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

3278: v_message_name VARCHAR2(30);
3279: rec_sua_d c_sua_d%ROWTYPE;
3280: v_s_result_type IGS_LOOKUPS_VIEW.lookup_code%TYPE := NULL;
3281: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
3282: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
3283: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
3284: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
3285: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
3286: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;

Line 3283: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

3279: rec_sua_d c_sua_d%ROWTYPE;
3280: v_s_result_type IGS_LOOKUPS_VIEW.lookup_code%TYPE := NULL;
3281: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
3282: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
3283: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
3284: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
3285: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
3286: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
3287: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;

Line 3284: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

3280: v_s_result_type IGS_LOOKUPS_VIEW.lookup_code%TYPE := NULL;
3281: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
3282: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
3283: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
3284: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
3285: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
3286: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
3287: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
3288: v_duplicate_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;