APPS.IGS_EN_GEN_002 dependencies on IGS_EN_STDNTPSHECSOP
Line 747: FROM IGS_EN_STDNTPSHECSOP scho
743: susa.end_dt IS NULL;
744: CURSOR c_scho
745: IS
746: SELECT 'x' 747: FROM IGS_EN_STDNTPSHECSOP scho 748: WHERE scho.person_id = p_person_id AND
749: scho.course_cd = p_course_cd AND
750: scho.start_dt <= p_effective_dt AND
751: (scho.end_dt IS NULL OR