1044:
1045:
1046: CURSOR c_dcnt_rsn IS
1047: SELECT DISCONTINUATION_REASON_CD
1048: FROM igs_en_dcnt_reasoncd
1049: WHERE NVL(closed_ind,'N') ='N'
1050: AND dflt_ind ='Y'
1051: AND dcnt_unit_ind ='Y';
1052:
1055: lv_message_name2 VARCHAR2(100);
1056: lv_return_type VARCHAR2(2);
1057: l_req_unit_failed BOOLEAN;
1058:
1059: l_dcnt_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;
1060:
1061: -- Cursor to get the coo_id of the student.
1062: CURSOR cur_coo_id IS
1063: SELECT coo_id coo_id
2699:
2700:
2701: CURSOR c_dcnt_rsn IS
2702: SELECT DISCONTINUATION_REASON_CD
2703: FROM igs_en_dcnt_reasoncd
2704: WHERE NVL(closed_ind,'N') ='N'
2705: AND dflt_ind ='Y'
2706: AND dcnt_unit_ind ='Y';
2707:
2710: lv_message_name2 VARCHAR2(100);
2711: lv_return_type VARCHAR2(2);
2712: l_req_unit_failed BOOLEAN;
2713:
2714: l_dcnt_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;
2715:
2716: -- Cursor to get the coo_id of the student.
2717: CURSOR cur_coo_id IS
2718: SELECT coo_id coo_id