APPS.IGS_AS_GEN_001 dependencies on IGS_AS_ASSESSMNT_ITM

Line 600: CURSOR c_ai (cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE) IS

596: gv_other_detail VARCHAR2 (255);
597: BEGIN -- assp_get_ai_a_type
598: -- Return the assessment type of an assessment item.
599: DECLARE
600: CURSOR c_ai (cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE) IS
601: SELECT assessment_type
602: FROM igs_as_assessmnt_itm ai
603: WHERE ai.ass_id = cp_ass_id;
604: v_ai_rec c_ai%ROWTYPE;

Line 602: FROM igs_as_assessmnt_itm ai

598: -- Return the assessment type of an assessment item.
599: DECLARE
600: CURSOR c_ai (cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE) IS
601: SELECT assessment_type
602: FROM igs_as_assessmnt_itm ai
603: WHERE ai.ass_id = cp_ass_id;
604: v_ai_rec c_ai%ROWTYPE;
605: BEGIN
606: OPEN c_ai (p_ass_id);