APPS.IGS_EN_VAL_SCA dependencies on IGS_PS_STAT

Line 1898: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE :='ACTIVE';

1894: || bdeviset 22-Dec-2004 Modifed cursor c_sct in enrp_val_sca_discont as part Bug#4083015.
1895: ------------------------------------------------------------------------------*/
1896: BEGIN
1897: DECLARE
1898: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE :='ACTIVE';
1899: cst_discontin CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE :='DISCONTIN';
1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';

Line 1909: IGS_PS_STAT cs

1905: l_dummy_boolean BOOLEAN;
1906: CURSOR c_cv IS
1907: SELECT 'x'
1908: FROM IGS_PS_VER cv,
1909: IGS_PS_STAT cs
1910: WHERE cv.course_cd = p_course_cd AND
1911: cv.version_number = p_version_number AND
1912: cs.course_status = cv.course_status AND
1913: cs.s_course_status <> cst_active;