[Home] [Help]
3299: l_stage Number;
3300:
3301: CURSOR cur_EvenSpCur IS
3302: SELECT sp.spread_curve_id
3303: FROM pa_spread_curves_b sp
3304: WHERE sp.spread_curve_code = 'EVEN'
3305: AND rownum = 1;
3306: l_evenSpCurveId NUMBER;
3307: BEGIN
3407: l_msg_data Varchar2(1000);
3408:
3409: CURSOR cur_EvenSpCur IS
3410: SELECT sp.spread_curve_id
3411: FROM pa_spread_curves_b sp
3412: WHERE sp.spread_curve_code = 'EVEN'
3413: AND rownum = 1;
3414: l_evenSpCurveId NUMBER;
3415:
3584: );
3585:
3586: CURSOR cur_EvenSpCur IS
3587: SELECT sp.spread_curve_id
3588: FROM pa_spread_curves_b sp
3589: WHERE sp.spread_curve_code = 'EVEN'
3590: AND rownum = 1;
3591: l_evenSpCurveId NUMBER;
3592: