APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_AS_SU_STMPTOUT_ALL

Line 7535: igs_en_su_attempt_all su, igs_as_su_stmptout_all suo1,

7531: -- than or equal to the reporting period end date.
7532: CURSOR c_unit_count IS
7533: SELECT count(*)
7534: FROM
7535: igs_en_su_attempt_all su, igs_as_su_stmptout_all suo1,
7536: igs_he_st_spa spa1, igs_he_st_spa spa2, igs_as_grd_sch_grade gsg
7537: WHERE su.person_id = suo1.person_id
7538: AND su.course_cd = suo1.course_cd
7539: AND su.unit_cd = suo1.unit_cd

Line 7554: FROM igs_as_su_stmptout_all suo2

7550: AND gsg.grade = suo1.grade
7551: AND gsg.version_number = suo1.version_number
7552: AND suo1.outcome_dt IN
7553: (SELECT MAX(suo2.outcome_dt)
7554: FROM igs_as_su_stmptout_all suo2
7555: WHERE suo2.person_id = suo1.person_id
7556: AND suo2.course_cd = suo1.course_cd
7557: AND suo2.finalised_outcome_ind = 'Y'
7558: AND suo2.unit_cd = suo1.unit_cd);