APPS.IGS_AS_DERIVE_GRADE dependencies on IGS_AS_SU_STMPTOUT_ALL

Line 1150: FROM igs_as_su_stmptout_all suao

1146: --
1147: --
1148: CURSOR cur_suao_final_man_ovr IS
1149: SELECT 'Y' finalized_manually_overridden
1150: FROM igs_as_su_stmptout_all suao
1151: WHERE suao.person_id = p_person_id
1152: AND suao.course_cd = p_course_cd
1153: AND suao.uoo_id = p_uoo_id
1154: AND suao.grading_period_cd = p_grading_period_cd

Line 1157: FROM igs_as_su_stmptout_all

1153: AND suao.uoo_id = p_uoo_id
1154: AND suao.grading_period_cd = p_grading_period_cd
1155: AND suao.outcome_dt =
1156: (SELECT MAX (outcome_dt)
1157: FROM igs_as_su_stmptout_all
1158: WHERE person_id = suao.person_id
1159: AND course_cd = suao.course_cd
1160: AND uoo_id = suao.uoo_id
1161: AND grading_period_cd = suao.grading_period_cd)

Line 1513: FROM igs_as_su_stmptout_all suao

1509: --
1510: --
1511: CURSOR cur_suao_final_man_ovr IS
1512: SELECT 'Y' finalized_manually_overridden
1513: FROM igs_as_su_stmptout_all suao
1514: WHERE suao.person_id = p_person_id
1515: AND suao.course_cd = p_course_cd
1516: AND suao.uoo_id = p_uoo_id
1517: AND suao.grading_period_cd = p_grading_period_cd

Line 1520: FROM igs_as_su_stmptout_all

1516: AND suao.uoo_id = p_uoo_id
1517: AND suao.grading_period_cd = p_grading_period_cd
1518: AND suao.outcome_dt =
1519: (SELECT MAX (outcome_dt)
1520: FROM igs_as_su_stmptout_all
1521: WHERE person_id = suao.person_id
1522: AND course_cd = suao.course_cd
1523: AND uoo_id = suao.uoo_id
1524: AND grading_period_cd = suao.grading_period_cd)

Line 1708: FROM igs_as_su_stmptout_all suao,

1704: SELECT DISTINCT suao.person_id,
1705: suao.course_cd,
1706: suao.unit_cd,
1707: suao.ci_start_dt
1708: FROM igs_as_su_stmptout_all suao,
1709: igs_en_su_attempt_all sua
1710: WHERE suao.person_id = sua.person_id
1711: AND suao.course_cd = sua.course_cd
1712: AND suao.uoo_id = sua.uoo_id