DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_EN_STDNT_PS_INTM

Line 5073: FROM igs_en_stdnt_ps_intm spi

5069:
5070: CURSOR c_susp IS
5071: SELECT start_dt,
5072: end_dt
5073: FROM igs_en_stdnt_ps_intm spi
5074: WHERE spi.person_id = p_person_id
5075: AND spi.course_cd = p_course_cd
5076: AND spi.start_dt <= p_enrl_end_dt
5077: AND spi.end_dt >= p_enrl_end_dt

Line 6439: FROM igs_en_stdnt_ps_intm spi

6435:
6436: CURSOR c_drm(cp_start_dt DATE, cp_end_dt DATE) IS
6437: SELECT start_dt,
6438: end_dt
6439: FROM igs_en_stdnt_ps_intm spi
6440: WHERE spi.person_id = p_person_id
6441: AND spi.course_cd = p_course_cd
6442: AND spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
6443: AND spi.start_dt<= cp_end_dt