3329: l_stage Number;
3330:
3331: CURSOR cur_EvenSpCur IS
3332: SELECT sp.spread_curve_id
3333: FROM pa_spread_curves_b sp
3334: WHERE sp.spread_curve_code = 'EVEN'
3335: AND rownum = 1;
3336: l_evenSpCurveId NUMBER;
3337: BEGIN
3439: l_msg_data Varchar2(1000);
3440:
3441: CURSOR cur_EvenSpCur IS
3442: SELECT sp.spread_curve_id
3443: FROM pa_spread_curves_b sp
3444: WHERE sp.spread_curve_code = 'EVEN'
3445: AND rownum = 1;
3446: l_evenSpCurveId NUMBER;
3447:
3616: );
3617:
3618: CURSOR cur_EvenSpCur IS
3619: SELECT sp.spread_curve_id
3620: FROM pa_spread_curves_b sp
3621: WHERE sp.spread_curve_code = 'EVEN'
3622: AND rownum = 1;
3623: l_evenSpCurveId NUMBER;
3624: