APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_INTM_TYPES

Line 1798: FROM igs_en_stdnt_ps_intm spi,igs_en_intm_types spt

1794: /* Intermission */
1795:
1796: CURSOR c_interm_date (l_c_course_cd VARCHAR2,p_student_id NUMBER,p_s_date DATE,p_e_date DATE) IS
1797: SELECT spi.start_dt,spi.end_dt,spi.intermission_type
1798: FROM igs_en_stdnt_ps_intm spi,igs_en_intm_types spt
1799: WHERE spi.person_id = p_student_id
1800: AND spi.course_cd = l_c_course_cd
1801: AND spi.intermission_type = spt.intermission_type
1802: AND spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')

Line 1822: FROM igs_en_intm_types

1818: /* Cursor to find whether the student is studying at another institution or not */
1819:
1820: CURSOR c_interm_date_study (l_intm_type VARCHAR2) IS
1821: SELECT 'x'
1822: FROM igs_en_intm_types
1823: WHERE intermission_type = l_intm_type
1824: AND study_antr_inst_ind = 'Y'
1825: AND APPR_REQD_IND = 'Y';
1826:

Line 1999: IGS_EN_INTM_TYPES eit

1995: --fetch the latest intermission of a student
1996: CURSOR c_latest_intrm(cp_course_cd VARCHAR2,cp_wthdrn_dt DATE) IS
1997: SELECT sci.start_dt , sci.end_dt
1998: FROM igs_en_stdnt_ps_intm sci,
1999: IGS_EN_INTM_TYPES eit
2000: WHERE sci.person_id = p_student_id
2001: AND sci.course_cd = cp_course_cd
2002: AND sci.end_dt <= cp_wthdrn_dt
2003: AND sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')