DBA Data[Home] [Help]

APPS.IGS_EN_GEN_012 dependencies on IGS_EN_INTM_TYPES

Line 2438: IGS_EN_INTM_TYPES eit,

2434: SELECT sca.person_id,
2435: sca.course_cd,
2436: sca.course_attempt_status
2437: FROM IGS_EN_STDNT_PS_INTM sci,
2438: IGS_EN_INTM_TYPES eit,
2439: IGS_EN_STDNT_PS_ATT sca
2440: WHERE sci.start_dt <= trunc(SYSDATE) AND
2441: sci.end_dt >= trunc(SYSDATE) AND
2442: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND

Line 2460: IGS_EN_INTM_TYPES eit,

2456: sci.start_dt,
2457: sci.logical_delete_date,
2458: cond_return_flag
2459: FROM IGS_EN_STDNT_PS_INTM sci,
2460: IGS_EN_INTM_TYPES eit,
2461: IGS_EN_STDNT_PS_ATT sca
2462: WHERE sci.end_dt < TRUNC(SYSDATE) AND
2463: sca.person_id = sci.person_id AND
2464: sca.course_cd = sci.course_cd AND