eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_ST_GEN_004 dependencies on IGS_EN_ATD_TYPE

Line 248: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%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;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;

Line 249: v_govt_attendance_type IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;

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;
252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;

Line 333: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;

329: v_prev_sub BOOLEAN;
330: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
331: v_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
332: v_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
333: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
334: v_major_course IGS_ST_GOVT_STDNT_EN.major_course%TYPE;
335: v_on BOOLEAN DEFAULT FALSE;
336: v_off BOOLEAN DEFAULT FALSE;
337: v_composite BOOLEAN DEFAULT FALSE;

Line 406: FROM IGS_EN_ATD_TYPE aty

402: FOR UPDATE OF essc.delete_snapshot_ind NOWAIT;
403: CURSOR c_get_att_type IS
404: SELECT aty.attendance_type,
405: aty.govt_attendance_type
406: FROM IGS_EN_ATD_TYPE aty
407: WHERE aty.govt_attendance_type = 2 AND
408: aty.upper_enr_load_range > 0;
409: CURSOR c_get_att_mode_1 IS
410: SELECT atm.attendance_mode,

Line 556: FROM IGS_EN_ATD_TYPE att

552: CURSOR c_att IS
553: SELECT att.attendance_type,
554: att.govt_attendance_type,
555: att.lower_enr_load_range
556: FROM IGS_EN_ATD_TYPE att
557: WHERE att.govt_attendance_type = 1 AND
558: att.lower_enr_load_range > 0;
559: CURSOR c_gse (
560: cp_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE) IS

Line 560: cp_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE) IS

556: FROM IGS_EN_ATD_TYPE att
557: WHERE att.govt_attendance_type = 1 AND
558: att.lower_enr_load_range > 0;
559: CURSOR c_gse (
560: cp_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE) IS
561: SELECT DISTINCT
562: gse.person_id
563: FROM IGS_ST_GOVT_STDNT_EN gse
564: WHERE gse.submission_yr = p_submission_yr AND