APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_STDNT_PS_INTM

Line 325: FROM igs_en_stdnt_ps_intm spi

321:
322: OR
323: (cp_nslc_condition = '3' AND course_attempt_status = 'INTERMIT'
324: And (EXISTS ( SELECT spi.person_id,spi.course_cd
325: FROM igs_en_stdnt_ps_intm spi
326: WHERE spi.person_id = spa.person_id
327: AND spi.course_cd = cp_course_cd
328: AND spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
329: AND(

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 1939: FROM igs_en_stdnt_ps_intm spi

1935: (cp_nslc_condition = '3' AND lapsed_dt BETWEEN p_s_date AND p_e_date)
1936: OR
1937: (cp_nslc_condition = '3' AND course_attempt_status = 'INTERMIT'
1938: And (EXISTS ( SELECT spi.person_id,spi.course_cd
1939: FROM igs_en_stdnt_ps_intm spi
1940: WHERE spi.person_id = pr.person_id
1941: AND spi.course_cd = pr.course_cd
1942: AND spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
1943: AND(

Line 1992: l_interm_prv_start_dt igs_en_stdnt_ps_intm.start_dt%TYPE;

1988: (cp_career_profile = 'N')
1989: );
1990:
1991: /* Previous Intermission */
1992: l_interm_prv_start_dt igs_en_stdnt_ps_intm.start_dt%TYPE;
1993: l_interm_prv_end_dt igs_en_stdnt_ps_intm.end_dt%TYPE;
1994:
1995: --fetch the latest intermission of a student
1996: CURSOR c_latest_intrm(cp_course_cd VARCHAR2,cp_wthdrn_dt DATE) IS

Line 1993: l_interm_prv_end_dt igs_en_stdnt_ps_intm.end_dt%TYPE;

1989: );
1990:
1991: /* Previous Intermission */
1992: l_interm_prv_start_dt igs_en_stdnt_ps_intm.start_dt%TYPE;
1993: l_interm_prv_end_dt igs_en_stdnt_ps_intm.end_dt%TYPE;
1994:
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

Line 1998: FROM igs_en_stdnt_ps_intm sci,

1994:
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