DBA Data[Home] [Help]

APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 689: FROM IGS_EN_SU_ATTEMPT_ALL sua,

685: sua.ci_sequence_number ,
686: sua.unit_attempt_status ,
687: sua.discontinued_dt ,
688: sua.uoo_id
689: FROM IGS_EN_SU_ATTEMPT_ALL sua,
690: IGS_HE_ST_UNT_VS_ALL hsu,
691: IGS_PS_UNIT_OFR_OPT_ALL uoo
692: WHERE sua.person_id = cp_person_id
693: AND sua.course_cd = cp_course_cd

Line 734: FROM igs_en_su_attempt_all

730: version_number,
731: ci_start_dt,
732: override_enrolled_cp ,
733: uoo_id
734: FROM igs_en_su_attempt_all
735: WHERE person_id = cp_person_id AND
736: course_cd = cp_course_cd AND
737: unit_attempt_status = cst_completed AND
738: (ci_start_dt BETWEEN p_fte_start_dt AND p_fte_end_dt) ;