APPS.IGS_EN_GEN_006 dependencies on IGS_EN_STDNT_PS_INTM

Line 604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;

600:
601: v_deceased_ind IGS_PE_PERSON.deceased_ind%TYPE;
602: v_instance_start_dt IGS_CA_INST.start_dt%TYPE;
603: v_instance_end_dt IGS_CA_INST.end_dt%TYPE;
604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
607: v_course_status
608: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE DEFAULT NULL;

Line 605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;

601: v_deceased_ind IGS_PE_PERSON.deceased_ind%TYPE;
602: v_instance_start_dt IGS_CA_INST.start_dt%TYPE;
603: v_instance_end_dt IGS_CA_INST.end_dt%TYPE;
604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
607: v_course_status
608: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE DEFAULT NULL;
609: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 705: FROM IGS_EN_STDNT_PS_INTM sci,

701: cop.ci_sequence_number = cp_ci_sequence_number;
702:
703: CURSOR c_sci IS
704: SELECT sci.end_dt
705: FROM IGS_EN_STDNT_PS_INTM sci,
706: IGS_EN_INTM_TYPES eit
707: WHERE sci.person_id = p_person_id AND
708: sci.course_cd = p_course_cd AND
709: eit.intermission_type(+) = sci.intermission_type AND

Line 1243: FROM IGS_EN_STDNT_PS_INTM sci,

1239:
1240: -- smaddali Modified cursor c_sci for build EN324 - bug#5091858
1241: CURSOR c_sci IS
1242: SELECT 'X'
1243: FROM IGS_EN_STDNT_PS_INTM sci,
1244: IGS_EN_INTM_TYPES eit
1245: WHERE sci.person_id = p_person_id AND
1246: sci.course_cd = p_course_cd AND
1247: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND