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.

[Home] [Help]

APPS.IGS_EN_GEN_004 dependencies on IGS_AS_SC_ATMPT_ENR

Line 431: -- If a student has the IGS_AS_SC_ATMPT_ENR.enr_form_due_dt set, then this

427:
428: BEGIN -- enrp_get_scae_due
429: -- Get the enrolment form due date for a nominated student IGS_PS_COURSE attempt
430: -- enrolment record. The logic is,
431: -- If a student has the IGS_AS_SC_ATMPT_ENR.enr_form_due_dt set, then this
432: -- is used. Else, it is search for in the enrolment period matching the
433: -- IGS_EN_CAL_CONF. enr_form_due_dt_alias (the latest date is selected)
434: DECLARE
435: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;

Line 435: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;

431: -- If a student has the IGS_AS_SC_ATMPT_ENR.enr_form_due_dt set, then this
432: -- is used. Else, it is search for in the enrolment period matching the
433: -- IGS_EN_CAL_CONF. enr_form_due_dt_alias (the latest date is selected)
434: DECLARE
435: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
436: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
437: CURSOR c_scae IS
438: SELECT scae.enr_form_due_dt
439: FROM IGS_AS_SC_ATMPT_ENR scae

Line 439: FROM IGS_AS_SC_ATMPT_ENR scae

435: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
436: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
437: CURSOR c_scae IS
438: SELECT scae.enr_form_due_dt
439: FROM IGS_AS_SC_ATMPT_ENR scae
440: WHERE scae.person_id = p_person_id AND
441: scae.course_cd = p_course_cd AND
442: scae.cal_type = p_cal_type AND
443: scae.ci_sequence_number = p_ci_sequence_number AND