DBA Data[Home] [Help]

APPS.IGS_EN_GEN_012 dependencies on IGS_EN_STDNT_PS_INTM

Line 2437: FROM IGS_EN_STDNT_PS_INTM sci,

2433: CURSOR c_sci_comm IS
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

Line 2459: FROM IGS_EN_STDNT_PS_INTM sci,

2455: sca.course_attempt_status,
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