[Home] [Help]
193:
194: CURSOR cur_control
195: IS
196: SELECT refund_dt_alias
197: FROM igs_fi_control;
198: l_refund_dt_alias igs_ca_da_inst.dt_alias%TYPE;
199:
200: CURSOR cur_alias_val (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
201: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
343: refund_cr_gl_ccid,
344: refund_dr_account_cd,
345: refund_cr_account_cd,
346: NVL(rec_installed,'N') rec_installed
347: FROM igs_fi_control;
348:
349: l_cur_refund cur_refund%ROWTYPE;
350:
351: BEGIN
349: l_cur_refund cur_refund%ROWTYPE;
350:
351: BEGIN
352:
353: -- If there is no record in the igs_fi_control table then the procedure will return
354: -- an error and assigns NULL to the OUT NOCOPY parameters
355: OPEN cur_refund;
356: FETCH cur_refund INTO l_cur_refund;
357: IF cur_refund%NOTFOUND THEN