APPS.IGS_AS_VAL_SUAAI dependencies on IGS_AS_ASSESSMNT_TYP

Line 38: v_examinable_ind IGS_AS_ASSESSMNT_TYP.examinable_ind%TYPE;

34: DECLARE
35: cst_no CONSTANT CHAR := 'N';
36: v_rows_exist BOOLEAN := FALSE;
37: v_valid_item BOOLEAN := FALSE;
38: v_examinable_ind IGS_AS_ASSESSMNT_TYP.examinable_ind%TYPE;
39: v_course_type IGS_AS_COURSE_TYPE.course_type%TYPE;
40: CURSOR c_atyp(
41: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS
42: SELECT atyp.examinable_ind

Line 43: FROM IGS_AS_ASSESSMNT_TYP atyp,

39: v_course_type IGS_AS_COURSE_TYPE.course_type%TYPE;
40: CURSOR c_atyp(
41: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS
42: SELECT atyp.examinable_ind
43: FROM IGS_AS_ASSESSMNT_TYP atyp,
44: IGS_AS_ASSESSMNT_ITM ai
45: WHERE ai.ass_id = cp_ass_id AND
46: ai.assessment_type = atyp.assessment_type;
47: CURSOR c_act(