APPS.IGS_PR_VAL_PRA dependencies on IGS_PS_STAT

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

221: gv_other_detail VARCHAR2(255);
222: BEGIN -- crsp_val_crv_active
223: -- Validate the IGS_PS_VER is ACTIVE
224: DECLARE
225: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE := 'ACTIVE';
226: v_dummy VARCHAR2(1);
227: CURSOR c_crv_crst IS
228: SELECT 'X'
229: FROM IGS_PS_VER cst,

Line 230: IGS_PS_STAT crst

226: v_dummy VARCHAR2(1);
227: CURSOR c_crv_crst IS
228: SELECT 'X'
229: FROM IGS_PS_VER cst,
230: IGS_PS_STAT crst
231: WHERE cst.course_cd = p_course_cd AND
232: cst.version_number = p_version_number AND
233: cst.course_status = crst.course_status AND
234: crst.s_course_status = cst_active;