DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_AS_GRD_SCH_GRADE

Line 247: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

243: DECLARE
244: v_grade igs_as_su_stmptout.grade%TYPE;
245: v_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
246: v_version_number igs_as_su_stmptout.version_number%TYPE;
247: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
248:
249: CURSOR c_suao (
250: cp_person_id igs_en_su_attempt.person_id%TYPE,
251: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 268: FROM igs_as_grd_sch_grade gsg

264: cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
265: cp_version_number igs_as_su_stmptout.version_number%TYPE,
266: cp_grade igs_as_su_stmptout.grade%TYPE) IS
267: SELECT gsg.s_result_type
268: FROM igs_as_grd_sch_grade gsg
269: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND
270: gsg.version_number = cp_version_number AND
271: gsg.grade = cp_grade;
272: BEGIN