81:
82: -- Cursor for validation of the Discontinuation Reason Code
83: CURSOR cur_dcnt_reason_cd(cp_dcnt_reason_cd IN VARCHAR2) IS
84: SELECT description
85: -- Bug#5018036: Replaced igs_en_dcnt_reasoncd_v by igs_en_dcnt_reasoncd_all
86: FROM igs_en_dcnt_reasoncd_all
87: WHERE discontinuation_reason_cd = cp_dcnt_reason_cd
88: AND closed_ind = g_no_ind
89: AND dcnt_unit_ind = g_yes_ind;
82: -- Cursor for validation of the Discontinuation Reason Code
83: CURSOR cur_dcnt_reason_cd(cp_dcnt_reason_cd IN VARCHAR2) IS
84: SELECT description
85: -- Bug#5018036: Replaced igs_en_dcnt_reasoncd_v by igs_en_dcnt_reasoncd_all
86: FROM igs_en_dcnt_reasoncd_all
87: WHERE discontinuation_reason_cd = cp_dcnt_reason_cd
88: AND closed_ind = g_no_ind
89: AND dcnt_unit_ind = g_yes_ind;
90: