119: ******************************************************************/
120:
121: CURSOR cur_cred (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
122: SELECT crtype.credit_class
123: FROM igs_fi_credits_all crd,
124: igs_fi_cr_types_all crtype
125: WHERE crd.credit_type_id = crtype.credit_type_id
126: AND crd.credit_id = cp_n_credit_id;
127:
244:
245:
246: CURSOR cur_cred (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
247: SELECT crtype.credit_class
248: FROM igs_fi_credits_all crd,
249: igs_fi_cr_types_all crtype
250: WHERE crd.credit_type_id = crtype.credit_type_id
251: AND crd.credit_id = cp_n_credit_id;
252: