DBA Data[Home] [Help]

APPS.QRM_CALCULATORS_P dependencies on XTR_AMOUNT_ACTIONS_V

Line 2313: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';

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;

Line 2315: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';

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

Line 2321: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';

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;

Line 2323: SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';

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;