APPS.IGS_AS_VAL_EI dependencies on IGS_AS_ASSESSMNT_ITM

Line 26: v_ai_sched_ind IGS_AS_ASSESSMNT_ITM.exam_scheduled_ind%TYPE;

22: v_active_unit BOOLEAN;
23: v_ust_exist BOOLEAN;
24:
25: v_atyp_exam_ind IGS_AS_ASSESSMNT_TYP.examinable_ind%TYPE;
26: v_ai_sched_ind IGS_AS_ASSESSMNT_ITM.exam_scheduled_ind%TYPE;
27:
28:
29: CURSOR c_atyp IS
30: SELECT atyp.examinable_ind,

Line 33: IGS_AS_ASSESSMNT_ITM ai

29: CURSOR c_atyp IS
30: SELECT atyp.examinable_ind,
31: ai.exam_scheduled_ind
32: FROM IGS_AS_ASSESSMNT_TYP atyp,
33: IGS_AS_ASSESSMNT_ITM ai
34: WHERE ai.ass_id = p_ass_id AND
35: atyp.assessment_type = ai.assessment_type;
36:
37: CURSOR c_ust IS