APPS.IGS_RE_GEN_002 dependencies on IGS_PS_UNIT_VER

Line 302: IGS_PS_UNIT_VER uv

298: CURSOR c_sua IS
299: SELECT sua.cal_type,
300: sua.ci_sequence_number
301: FROM IGS_EN_SU_ATTEMPT sua,
302: IGS_PS_UNIT_VER uv
303: WHERE sua.person_id = p_person_id AND
304: sua.course_cd = p_course_cd AND
305: sua.unit_cd = uv.unit_cd AND
306: sua.version_number = uv.version_number AND

Line 581: v_research_unit_ind IGS_PS_UNIT_VER.research_unit_ind%TYPE;

577: -- attendance type
578: -- less Days prior to the IGS_PS_COURSE commencement date, where the date is
579: -- within the teaching period
580: DECLARE
581: v_research_unit_ind IGS_PS_UNIT_VER.research_unit_ind%TYPE;
582: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
583: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;

Line 610: FROM IGS_PS_UNIT_VER uv

606: v_last_hist_end_dt DATE;
607: v_diff_percentage NUMBER;
608: CURSOR c_uv IS
609: SELECT uv.research_unit_ind
610: FROM IGS_PS_UNIT_VER uv
611: WHERE uv.unit_cd = p_unit_cd AND
612: uv.version_number = p_unit_version_number;
613: CURSOR c_ca IS
614: SELECT ca.sequence_number,

Line 675: --1. Load details from the IGS_PS_UNIT version

671: cah.hist_start_dt <= p_effective_dt AND
672: cah.hist_end_dt >= cp_intermit_start_dt
673: ORDER BY cah.hist_start_dt;
674: BEGIN
675: --1. Load details from the IGS_PS_UNIT version
676: OPEN c_uv;
677: FETCH c_uv INTO v_research_unit_ind;
678: IF c_uv%NOTFOUND THEN
679: CLOSE c_uv;