APPS.IGS_AS_VAL_SUAAI dependencies on IGS_AS_ASSESSMNT_ITM

Line 41: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS

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
43: FROM IGS_AS_ASSESSMNT_TYP atyp,
44: IGS_AS_ASSESSMNT_ITM ai
45: WHERE ai.ass_id = cp_ass_id AND

Line 44: IGS_AS_ASSESSMNT_ITM ai

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(
48: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS

Line 48: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS

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(
48: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS
49: SELECT course_type
50: FROM IGS_AS_COURSE_TYPE
51: WHERE ass_id = cp_ass_id;
52: BEGIN