15: RETURN boolean AS
16: NO_RECORDS_FOUND EXCEPTION;
17: BEGIN
18: DECLARE
19: v_census_date IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
20: CURSOR c_census_dt IS
21: SELECT census_dt_alias
22: FROM IGS_GE_S_GEN_CAL_CON
23: WHERE s_control_num = 1;
18: DECLARE
19: v_census_date IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
20: CURSOR c_census_dt IS
21: SELECT census_dt_alias
22: FROM IGS_GE_S_GEN_CAL_CON
23: WHERE s_control_num = 1;
24: CURSOR c_sua_details(
25: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,
26: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE) IS