332: DECLARE
333: v_check VARCHAR2(1);
334: CURSOR c_person_exist IS
335: SELECT 'x'
336: FROM IGS_EN_STDNT_PS_ATT
337: WHERE person_id = p_person_id AND
338: course_cd = p_course_cd AND
339: course_attempt_status IN
340: ('ENROLLED', 'INACTIVE', 'INTERMIT');
379: DECLARE
380: v_check VARCHAR2(1);
381: CURSOR c_person_exist IS
382: SELECT 'x'
383: FROM IGS_EN_STDNT_PS_ATT
384: WHERE person_id = p_person_id AND
385: course_attempt_status IN
386: ('ENROLLED', 'INACTIVE', 'INTERMIT');
387: BEGIN
430: WHERE S_ENCMB_EFFECT_TYPE = p_effect_type AND
431: apply_to_course_ind = 'Y';
432: CURSOR c_sca_exist IS
433: SELECT 'x'
434: FROM IGS_EN_STDNT_PS_ATT sca
435: WHERE sca.person_id = p_person_id AND
436: sca.course_attempt_status IN ('ENROLLED', 'INACTIVE', 'INTERMIT');
437: BEGIN
438: p_message_name := null;