APPS.IGS_ST_GEN_004 dependencies on IGS_EN_STDNT_PS_ATT

Line 246: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

242: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'08/31');
243: v_ess_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE;
244: v_effective_dt DATE;
245: v_unit_effective_dt DATE;
246: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
247: v_derived_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
248: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
249: v_govt_attendance_type IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;

Line 247: v_derived_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

243: v_ess_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE;
244: v_effective_dt DATE;
245: v_unit_effective_dt DATE;
246: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
247: v_derived_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
248: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
249: v_govt_attendance_type IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
250: v_attendance_mode_1 IGS_EN_ATD_MODE.attendance_mode%TYPE;
251: v_govt_attendance_mode_1 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;

Line 590: IGS_EN_STDNT_PS_ATT sca

586: gse.course_cd,
587: SUM(gslo.eftsu)
588: FROM IGS_ST_GOVT_STDNT_EN gse,
589: IGS_ST_GVT_STDNTLOAD gslo,
590: IGS_EN_STDNT_PS_ATT sca
591: WHERE gse.submission_yr = p_submission_yr AND
592: gse.submission_number = p_submission_number AND
593: gse.person_id = cp_person_id AND
594: 1 < (SELECT COUNT(DISTINCT gse2.course_cd)