APPS.IGS_AS_GEN_003 dependencies on IGS_AS_SASSESS_TYPE

Line 103: -- is defined in the IGS_AS_SASSESS_TYPE table.

99: -- 3. The default exam IGS_AD_LOCATION for the enrolled IGS_PS_UNIT attempt
100: -- If the assessment id is passed as a parameter, the routine will determine
101: -- whether the examination is a non-central examination, in which case all
102: -- students are grouped under a single examination IGS_AD_LOCATION. This IGS_AD_LOCATION
103: -- is defined in the IGS_AS_SASSESS_TYPE table.
104: DECLARE
105: v_nonc_exam_loc_cd IGS_AS_SASSESS_TYPE.non_cntrl_exam_loc_cd%TYPE;
106: v_sua_location IGS_AD_LOCATION.location_cd%TYPE;
107: v_sca_location IGS_AD_LOCATION.location_cd%TYPE;

Line 105: v_nonc_exam_loc_cd IGS_AS_SASSESS_TYPE.non_cntrl_exam_loc_cd%TYPE;

101: -- whether the examination is a non-central examination, in which case all
102: -- students are grouped under a single examination IGS_AD_LOCATION. This IGS_AD_LOCATION
103: -- is defined in the IGS_AS_SASSESS_TYPE table.
104: DECLARE
105: v_nonc_exam_loc_cd IGS_AS_SASSESS_TYPE.non_cntrl_exam_loc_cd%TYPE;
106: v_sua_location IGS_AD_LOCATION.location_cd%TYPE;
107: v_sca_location IGS_AD_LOCATION.location_cd%TYPE;
108: CURSOR c_sat IS
109: SELECT sat.non_cntrl_exam_loc_cd

Line 112: IGS_AS_SASSESS_TYPE sat

108: CURSOR c_sat IS
109: SELECT sat.non_cntrl_exam_loc_cd
110: FROM IGS_AS_ASSESSMNT_ITM ai,
111: IGS_AS_ASSESSMNT_TYP atyp,
112: IGS_AS_SASSESS_TYPE sat
113: WHERE ai.ass_id = p_ass_id AND
114: atyp.assessment_type = ai.assessment_type AND
115: atyp.s_assessment_type = 'NONCENTRAL' AND
116: sat.s_assessment_type= atyp.s_assessment_type;