96: uv.research_unit_ind <> 'N';
97: v_uv_exists VARCHAR2(1);
98: CURSOR c_ca IS
99: SELECT ca.sequence_number
100: FROM IGS_RE_CANDIDATURE ca
101: WHERE ca.person_id = p_person_id AND
102: (ca.sca_course_cd IS NOT NULL AND
103: ca.sca_course_cd = p_course_cd);
104: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
100: FROM IGS_RE_CANDIDATURE ca
101: WHERE ca.person_id = p_person_id AND
102: (ca.sca_course_cd IS NOT NULL AND
103: ca.sca_course_cd = p_course_cd);
104: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
105: CURSOR c_rsup(
106: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE) IS
107: SELECT rsup.start_dt
108: FROM IGS_RE_SPRVSR rsup
102: (ca.sca_course_cd IS NOT NULL AND
103: ca.sca_course_cd = p_course_cd);
104: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
105: CURSOR c_rsup(
106: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE) IS
107: SELECT rsup.start_dt
108: FROM IGS_RE_SPRVSR rsup
109: WHERE rsup.ca_person_id = p_person_id AND
110: rsup.ca_sequence_number = cp_ca_sequence_number AND
121: AND course_cd = p_course_cd;
122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
123:
124: FUNCTION respl_check_percentage(
125: pl_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
126: pl_check_dt IGS_RE_SPRVSR.start_dt%TYPE)
127: RETURN BOOLEAN AS
128:
129: BEGIN
357: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
358:
359: CURSOR c_ca IS
360: SELECT 'x'
361: FROM IGS_RE_CANDIDATURE ca
362: WHERE ca.person_id = p_person_id AND
363: (ca.sca_course_cd IS NULL OR
364: ca.sca_course_cd = p_course_cd);
365: v_ca_exists VARCHAR2(1);