APPS.IGS_RE_GEN_002 dependencies on IGS_EN_STDNT_PS_INTM
Line 648: FROM IGS_EN_STDNT_PS_INTM sci,
644: cp_effective_start_dt DATE)
645: IS
646: SELECT sci.start_dt,
647: sci.end_dt 648: FROM IGS_EN_STDNT_PS_INTM sci, 649: IGS_EN_INTM_TYPES eit
650: WHERE sci.person_id = p_person_id AND
651: sci.course_cd = p_course_cd AND
652: sci.start_dt <= p_effective_dt AND