APPS.IGS_IN_GEN_001 dependencies on IGS_EN_STDNT_PS_INTM

Line 765: v_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;

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
769: FROM IGS_EN_DCNT_REASONCD drc

Line 773: FROM IGS_EN_STDNT_PS_INTM sci,

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,
774: IGS_EN_INTM_TYPES eit
775: WHERE sci.person_id = p_person_id AND
776: sci.course_cd = p_course_cd AND
777: sci.start_dt <= TRUNC(SYSDATE) AND

Line 923: v_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;

919: AS
920: gv_other_detail VARCHAR2(255);
921: BEGIN -- inqp_get_sci
922: DECLARE
923: v_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
924: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
925: v_sci_voluntary_ind IGS_EN_STDNT_PS_INTM.voluntary_ind%TYPE;
926: CURSOR c_sci IS
927: SELECT sci.start_dt,

Line 924: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;

920: gv_other_detail VARCHAR2(255);
921: BEGIN -- inqp_get_sci
922: DECLARE
923: v_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
924: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
925: v_sci_voluntary_ind IGS_EN_STDNT_PS_INTM.voluntary_ind%TYPE;
926: CURSOR c_sci IS
927: SELECT sci.start_dt,
928: sci.end_dt,

Line 925: v_sci_voluntary_ind IGS_EN_STDNT_PS_INTM.voluntary_ind%TYPE;

921: BEGIN -- inqp_get_sci
922: DECLARE
923: v_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
924: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
925: v_sci_voluntary_ind IGS_EN_STDNT_PS_INTM.voluntary_ind%TYPE;
926: CURSOR c_sci IS
927: SELECT sci.start_dt,
928: sci.end_dt,
929: sci.voluntary_ind

Line 930: FROM IGS_EN_STDNT_PS_INTM sci,

926: CURSOR c_sci IS
927: SELECT sci.start_dt,
928: sci.end_dt,
929: sci.voluntary_ind
930: FROM IGS_EN_STDNT_PS_INTM sci,
931: IGS_EN_INTM_TYPES eit
932: WHERE sci.person_id = p_person_id and
933: sci.course_cd = p_course_cd and
934: sci.end_dt >= TRUNC(SYSDATE) AND