2309: END IF;
2310: --determine pay or receive
2311: IF p_deal_subtype = 'FUND' THEN
2312: IF p_contract_rate > p_settlement_rate THEN
2313: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';
2314: ELSIF p_contract_rate < p_settlement_rate THEN
2315: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';
2316: ELSE
2317: p_action:=null;
2311: IF p_deal_subtype = 'FUND' THEN
2312: IF p_contract_rate > p_settlement_rate THEN
2313: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';
2314: ELSIF p_contract_rate < p_settlement_rate THEN
2315: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';
2316: ELSE
2317: p_action:=null;
2318: END IF;
2319: ELSE
2317: p_action:=null;
2318: END IF;
2319: ELSE
2320: IF p_contract_rate > p_settlement_rate THEN
2321: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';
2322: ELSIF p_contract_rate < p_settlement_rate THEN
2323: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';
2324: ELSE
2325: p_action:=null;
2319: ELSE
2320: IF p_contract_rate > p_settlement_rate THEN
2321: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';
2322: ELSIF p_contract_rate < p_settlement_rate THEN
2323: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';
2324: ELSE
2325: p_action:=null;
2326: END IF;
2327: END IF;