[Home] [Help]
386: l_v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL;
387: l_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE := NULL;
388:
389: -- Cursor to get optional payment Indicator for a given fee type
390: CURSOR cur_optional_payment_ind(cp_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
391: SELECT optional_payment_ind
392: FROM igs_fi_fee_type
393: WHERE fee_type = cp_fee_type;
394:
391: SELECT optional_payment_ind
392: FROM igs_fi_fee_type
393: WHERE fee_type = cp_fee_type;
394:
395: l_v_optional_payment_ind igs_fi_fee_type_all.optional_payment_ind%TYPE;
396: l_v_unit_transferred VARCHAR2(1);
397:
398: l_v_disc_reason igs_en_su_attempt.dcnt_reason_cd%TYPE;
399: