82: CURSOR c_org_unit_cd (L_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
83: SELECT owner_org_unit_cd FROM igs_ps_unit_ofr_opt_all WHERE uoo_id = l_uoo_id;
84: v_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type;
85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
87: l_org_unit_cd igs_as_inc_grd_cprof.org_unit_cd%TYPE,
88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
90: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
83: SELECT owner_org_unit_cd FROM igs_ps_unit_ofr_opt_all WHERE uoo_id = l_uoo_id;
84: v_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type;
85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
87: l_org_unit_cd igs_as_inc_grd_cprof.org_unit_cd%TYPE,
88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
90: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
91: default_mark
84: v_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type;
85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
87: l_org_unit_cd igs_as_inc_grd_cprof.org_unit_cd%TYPE,
88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
90: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
91: default_mark
92: FROM igs_as_inc_grd_cprof_v
85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
87: l_org_unit_cd igs_as_inc_grd_cprof.org_unit_cd%TYPE,
88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
90: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
91: default_mark
92: FROM igs_as_inc_grd_cprof_v
93: WHERE incomplete_grade = l_incomplete_grade
88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
90: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
91: default_mark
92: FROM igs_as_inc_grd_cprof_v
93: WHERE incomplete_grade = l_incomplete_grade
94: AND org_unit_cd = l_org_unit_cd
95: AND grading_schema_cd = l_grading_schema_cd
96: AND version_number = l_version_number;
94: AND org_unit_cd = l_org_unit_cd
95: AND grading_schema_cd = l_grading_schema_cd
96: AND version_number = l_version_number;
97:
98: CURSOR c_dead_line(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
99: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
100: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
101: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
102: default_mark
95: AND grading_schema_cd = l_grading_schema_cd
96: AND version_number = l_version_number;
97:
98: CURSOR c_dead_line(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
99: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
100: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
101: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
102: default_mark
103: FROM igs_as_inc_grd_cprof_v
96: AND version_number = l_version_number;
97:
98: CURSOR c_dead_line(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
99: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
100: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
101: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
102: default_mark
103: FROM igs_as_inc_grd_cprof_v
104: WHERE incomplete_grade = l_incomplete_grade
99: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
100: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
101: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
102: default_mark
103: FROM igs_as_inc_grd_cprof_v
104: WHERE incomplete_grade = l_incomplete_grade
105: AND grading_schema_cd = l_grading_schema_cd
106: AND version_number = l_version_number;
107: