APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PR_STDNT_PR_OU

Line 5281: l_progression_out_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE;

5277: of program before or during the HESA reporting period
5278: ***************************************************************/
5279:
5280: l_he_code_map_val IGS_HE_CODE_MAP_VAL%ROWTYPE := NULL;
5281: l_progression_out_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE;
5282: l_prev_start_dt IGS_CA_INST.start_dt%TYPE;
5283: l_prev_applied_dt IGS_PR_STDNT_PR_OU.applied_dt%TYPE;
5284: l_prev_decision_dt IGS_PR_STDNT_PR_OU.decision_dt%TYPE;
5285: l_minimum_date DATE;

Line 5283: l_prev_applied_dt IGS_PR_STDNT_PR_OU.applied_dt%TYPE;

5279:
5280: l_he_code_map_val IGS_HE_CODE_MAP_VAL%ROWTYPE := NULL;
5281: l_progression_out_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE;
5282: l_prev_start_dt IGS_CA_INST.start_dt%TYPE;
5283: l_prev_applied_dt IGS_PR_STDNT_PR_OU.applied_dt%TYPE;
5284: l_prev_decision_dt IGS_PR_STDNT_PR_OU.decision_dt%TYPE;
5285: l_minimum_date DATE;
5286:
5287: -- Cursor to fetch the STudent Progression Outcome Type

Line 5284: l_prev_decision_dt IGS_PR_STDNT_PR_OU.decision_dt%TYPE;

5280: l_he_code_map_val IGS_HE_CODE_MAP_VAL%ROWTYPE := NULL;
5281: l_progression_out_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE;
5282: l_prev_start_dt IGS_CA_INST.start_dt%TYPE;
5283: l_prev_applied_dt IGS_PR_STDNT_PR_OU.applied_dt%TYPE;
5284: l_prev_decision_dt IGS_PR_STDNT_PR_OU.decision_dt%TYPE;
5285: l_minimum_date DATE;
5286:
5287: -- Cursor to fetch the STudent Progression Outcome Type
5288: CURSOR cur_prog_out_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

Line 5293: FROM IGS_PR_STDNT_PR_OU spo,

5289: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
5290: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5291: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
5292: SELECT progression_outcome_type,ca.start_dt , spo.decision_dt, spo.applied_dt
5293: FROM IGS_PR_STDNT_PR_OU spo,
5294: IGS_CA_INST ca
5295: WHERE spo.person_id = cp_person_id AND
5296: spo.course_cd = cp_course_cd AND
5297: -- Select Approved Progression Outcomes