APPS.IGS_EN_VAL_SUA dependencies on IGS_AD_ADM_UT_STA_GD

Line 1598: IGS_AD_ADM_UT_STA_GD ausg

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
1602: gsg.grading_schema_cd = gs.grading_schema_cd AND

Line 1689: FROM IGS_AD_ADM_UT_STA_GD ausg

1685: CURSOR c_ausg_exists
1686: (cp_admin_unit_status
1687: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
1688: SELECT 'X'
1689: FROM IGS_AD_ADM_UT_STA_GD ausg
1690: WHERE ausg.administrative_unit_status = cp_admin_unit_status;
1691:
1692: CURSOR c_ausg_count
1693: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,

Line 1697: FROM igs_ad_adm_ut_sta_gd ausg,

1693: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1694: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
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

Line 1721: FROM igs_ad_adm_ut_sta_gd ausg,

1717: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1718: SELECT ausg.grading_schema_cd,
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

Line 1747: IGS_AD_ADM_UT_STA_GD ausg,

1743: ausg.version_number,
1744: ausg.grade
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