DBA Data[Home] [Help]

APPS.IGS_EN_GEN_006 dependencies on IGS_EN_INTM_TYPES

Line 706: IGS_EN_INTM_TYPES eit

702:
703: CURSOR c_sci IS
704: SELECT sci.end_dt
705: FROM IGS_EN_STDNT_PS_INTM sci,
706: IGS_EN_INTM_TYPES eit
707: WHERE sci.person_id = p_person_id AND
708: sci.course_cd = p_course_cd AND
709: eit.intermission_type(+) = sci.intermission_type AND
710: ((eit.appr_reqd_ind = 'Y' AND sci.approved = 'Y') OR (eit.appr_reqd_ind = 'N'))

Line 1244: IGS_EN_INTM_TYPES eit

1240: -- smaddali Modified cursor c_sci for build EN324 - bug#5091858
1241: CURSOR c_sci IS
1242: SELECT 'X'
1243: FROM IGS_EN_STDNT_PS_INTM sci,
1244: IGS_EN_INTM_TYPES eit
1245: WHERE sci.person_id = p_person_id AND
1246: sci.course_cd = p_course_cd AND
1247: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND
1248: eit.intermission_type = sci.intermission_type AND