APPS.IGS_AS_GEN_002 dependencies on IGS_AS_ASSESSMNT_TYP

Line 10: -- for an assessment type from the IGS_AS_ASSESSMNT_TYP table.

6: ) RETURN VARCHAR2 IS
7: gv_other_detail VARCHAR2 (255);
8: BEGIN -- assp_get_atyp_exmnbl
9: -- This module fetches the value for the examinable_ind
10: -- for an assessment type from the IGS_AS_ASSESSMNT_TYP table.
11: DECLARE
12: CURSOR c_atyp IS
13: SELECT examinable_ind
14: FROM igs_as_assessmnt_typ

Line 14: FROM igs_as_assessmnt_typ

10: -- for an assessment type from the IGS_AS_ASSESSMNT_TYP table.
11: DECLARE
12: CURSOR c_atyp IS
13: SELECT examinable_ind
14: FROM igs_as_assessmnt_typ
15: WHERE assessment_type = p_assessment_type;
16: v_atyp_rec c_atyp%ROWTYPE;
17: BEGIN
18: -- Fetch the examinable indicator

Line 397: FROM igs_as_assessmnt_typ atyp,

393: -- Return the system type of an assessment item.
394: DECLARE
395: CURSOR c_atyp (cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE) IS
396: SELECT s_assessment_type
397: FROM igs_as_assessmnt_typ atyp,
398: igs_as_assessmnt_itm ai
399: WHERE ai.ass_id = cp_ass_id
400: AND ai.assessment_type = atyp.assessment_type;
401: v_atyp_rec c_atyp%ROWTYPE;