65:
66:
67: CURSOR c_grade_lookup IS
68: SELECT lookup_code
69: FROM AMS_LOOKUPS
70: WHERE lookup_type = l_grade_lookup;
71:
72: CURSOR c_reason_lookup IS
73: SELECT lookup_code
70: WHERE lookup_type = l_grade_lookup;
71:
72: CURSOR c_reason_lookup IS
73: SELECT lookup_code
74: FROM AMS_LOOKUPS
75: WHERE lookup_type = l_reason_lookup;
76:
77: CURSOR c_grade(l_cur_lookup_code Varchar2) IS
78: SELECT lookup_code
75: WHERE lookup_type = l_reason_lookup;
76:
77: CURSOR c_grade(l_cur_lookup_code Varchar2) IS
78: SELECT lookup_code
79: FROM AMS_LOOKUPS
80: WHERE lookup_type = l_grade_lookup
81: AND lookup_code = l_cur_lookup_code;
82:
83: CURSOR c_reason(l_cur_res_code Varchar2) IS
81: AND lookup_code = l_cur_lookup_code;
82:
83: CURSOR c_reason(l_cur_res_code Varchar2) IS
84: SELECT lookup_code
85: FROM AMS_LOOKUPS
86: WHERE lookup_type = l_reason_lookup
87: AND lookup_code = l_cur_res_code;
88:
89: CURSOR c_source_code(l_cur_source_code Varchar2) IS