[Home] [Help]
46: OR (anm.method = 'ASSESSMENT'
47: AND (EXISTS ( SELECT 'X'
48: FROM igs_ps_unitass_item uooai,
49: igs_as_assessmnt_itm ai,
50: igs_as_assessmnt_typ ast
51: WHERE uooai.uoo_id = uoo.uoo_id
52: AND uooai.logical_delete_dt IS NULL
53: AND uooai.ass_id = ai.ass_id
54: AND ai.assessment_type = anm.assessment_type
56: AND ast.anon_grading_ind = 'Y')
57: OR EXISTS ( SELECT 'X'
58: FROM igs_as_unitass_item uoai,
59: igs_as_assessmnt_itm ai,
60: igs_as_assessmnt_typ ast,
61: igs_as_unit_class uc
62: WHERE uoai.unit_cd = uoo.unit_cd
63: AND uoai.version_number = uoo.version_number
64: AND uoai.cal_type = uoo.cal_type
93: AND anm.load_cal_type = ttl.load_cal_type
94: AND (EXISTS ( SELECT 'X'
95: FROM igs_ps_unitass_item uooai,
96: igs_as_assessmnt_itm ai,
97: igs_as_assessmnt_typ ast
98: WHERE uooai.uoo_id = uoo.uoo_id
99: AND uooai.ass_id = p_ass_id
100: AND uooai.logical_delete_dt IS NULL
101: AND uooai.ass_id = ai.ass_id
103: AND ast.anon_grading_ind = 'Y')
104: OR EXISTS ( SELECT 'X'
105: FROM igs_as_unitass_item uoai,
106: igs_as_assessmnt_itm ai,
107: igs_as_assessmnt_typ ast,
108: igs_as_unit_class uc
109: WHERE uoai.unit_cd = uoo.unit_cd
110: AND uoai.version_number = uoo.version_number
111: AND uoai.cal_type = uoo.cal_type
181: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
182: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
183: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
185: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
186: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
187: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE )
188: IS
189: /*
434: SELECT DISTINCT sua.person_id, ast.assessment_type
435: FROM igs_ca_teach_to_load_v ttl,
436: igs_en_su_attempt sua,
437: igs_ps_unit_ofr_opt uoo,
438: igs_as_assessmnt_typ ast
439: WHERE sua.unit_attempt_status = 'ENROLLED'
440: AND ttl.load_cal_type = cp_load_cal_type
441: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
442: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
525: ast.assessment_type
526: FROM igs_ca_teach_to_load_v ttl,
527: igs_en_su_attempt sua,
528: igs_ps_unit_ofr_opt uoo,
529: igs_as_assessmnt_typ ast
530: WHERE sua.unit_attempt_status = 'ENROLLED'
531: AND ttl.load_cal_type = cp_load_cal_type
532: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
533: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
1009: OR ( p_unit_grading_ind = 'N'
1010: AND p_ass_id IS NOT NULL
1011: AND uoo.anon_assess_grading_ind = 'Y'
1012: AND 'Y' = ( SELECT ast.anon_grading_ind
1013: FROM igs_as_assessmnt_typ ast,
1014: igs_as_assessmnt_itm ai
1015: WHERE ai.ass_id = p_ass_id
1016: AND ai.assessment_type = ast.assessment_type)));
1017:
1043: OR ( p_unit_grading_ind = 'N'
1044: AND p_ass_id IS NOT NULL
1045: AND uoo.anon_assess_grading_ind = 'Y'
1046: AND 'Y' = ( SELECT ast.anon_grading_ind
1047: FROM igs_as_assessmnt_typ ast,
1048: igs_as_assessmnt_itm ai
1049: WHERE ai.ass_id = p_ass_id
1050: AND ai.assessment_type = ast.assessment_type)));
1051:
1085: OR ( p_ass_id IS NOT NULL
1086: AND p_unit_grading_ind = 'N'
1087: AND uoo.anon_assess_grading_ind = 'Y'
1088: AND ania.assessment_type = (SELECT ai.assessment_type
1089: FROM igs_as_assessmnt_typ ast,
1090: igs_as_assessmnt_itm ai
1091: WHERE ai.ass_id = p_ass_id
1092: AND ai.assessment_type = ast.assessment_type
1093: AND ast.anon_grading_ind = 'Y')));
1324: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1325: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1326: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1327: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1328: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
1329: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1330: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1331: ) RETURN VARCHAR2 IS
1332: /*