[Home] [Help]
1721: crv.course_cd = sca.course_cd AND
1722: crv.version_number = sca.version_number;
1723: CURSOR c_ins IS
1724: SELECT 'x'
1725: FROM IGS_OR_INSTITUTION ins,
1726: IGS_OR_INST_STAT ist
1727: WHERE ins.local_institution_ind = 'Y' AND
1728: ins.govt_institution_cd = 2239 AND
1729: ist.institution_status = ins.institution_status AND
1736: -- 1. If the government value for the
1737: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option
1738: -- is 70, then the IGS_PS_VER.govt_special_course_type for the
1739: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 15, and vice-versa, and the
1740: -- IGS_OR_INSTITUTION code must be 2239 (Australian Maritime College)
1741: -- (DEETYA validation 1670, 1671).
1742: -- set the default message number
1743: p_message_name := null;
1744: -- retrieving the govt. value for the student_course_
2822: v_institution_3037 BOOLEAN DEFAULT FALSE;
2823: v_exit BOOLEAN DEFAULT FALSE;
2824: CURSOR c_ins IS
2825: SELECT ins.govt_institution_cd
2826: FROM IGS_OR_INSTITUTION ins,
2827: IGS_OR_INST_STAT ist
2828: WHERE ins.local_institution_ind = 'Y' AND
2829: ist.institution_status = ins.institution_status AND
2830: ist.s_institution_status = 'ACTIVE';