APPS.IGS_IN_GEN_001 dependencies on IGS_AS_SC_ATTEMPT_H

Line 766: v_scah_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;

762: cst_intermit CONSTANT VARCHAR2(8) := 'INTERMIT';
763: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
764: v_drc_description IGS_EN_DCNT_REASONCD.description%TYPE;
765: v_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
766: v_scah_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;
767: CURSOR c_drc IS
768: SELECT drc.description
769: FROM IGS_EN_DCNT_REASONCD drc
770: WHERE drc.discontinuation_reason_cd = p_discontinuation_reason_cd;

Line 784: FROM IGS_AS_SC_ATTEMPT_H scah

780: eit.intermission_type = sci.intermission_type AND
781: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY');
782: CURSOR c_scah IS
783: SELECT scah.hist_end_dt
784: FROM IGS_AS_SC_ATTEMPT_H scah
785: WHERE person_id = p_person_id AND
786: course_cd = p_course_cd AND
787: course_attempt_status IS NOT NULL
788: ORDER BY hist_end_dt DESC; --(use the first record)