APPS.IGS_IN_GEN_001 dependencies on IGS_EN_DCNT_REASONCD

Line 764: v_drc_description IGS_EN_DCNT_REASONCD.description%TYPE;

760: cst_discontin CONSTANT VARCHAR2(9) := 'DISCONTIN';
761: cst_lapsed CONSTANT VARCHAR2(6) := 'LAPSED';
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

Line 769: FROM IGS_EN_DCNT_REASONCD drc

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;
771: CURSOR c_sci IS
772: SELECT sci.start_dt
773: FROM IGS_EN_STDNT_PS_INTM sci,