APPS.XTR_REVAL_PROCESS_P dependencies on XTR_BOND_ISSUES

Line 128: from XTR_BOND_ISSUES

124: l_ric_code varchar2(50);
125:
126: cursor GET_BOND_RIC_CODE is
127: select ric_code
128: from XTR_BOND_ISSUES
129: where bond_issue_code=l_bond_issue
130: and ric_code IS NOT NULL;
131:
132: cursor BOND_PRICE is

Line 1496: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;

1492: r_fx_rate xtr_revl_fx_rate; -- record type
1493: r_md_in xtr_market_data_p.md_from_set_in_rec_type;
1494: r_md_out xtr_market_data_p.md_from_set_out_rec_type;
1495: l_market_set VARCHAR2(30);
1496: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;
1497: l_dummy NUMBER;
1498: l_dummy1 NUMBER;
1499: l_knock_type XTR_DEALS.knock_type%TYPE;
1500: l_knock_date DATE;

Line 1542: from XTR_BOND_ISSUES

1538: elsif rec.expiry_date <= rec.revldate and rec.status_code = 'EXPIRED' then -- realized
1539: if rec.contract_code is not null then
1540: select RIC_CODE
1541: into l_ric_code
1542: from XTR_BOND_ISSUES
1543: where bond_issue_code = rec.contract_code;
1544: xtr_revl_mds_init(r_md_in, l_market_set, C_SOURCE,
1545: C_BOND_IND, rec.expiry_date, null, rec.currencya, NULL,
1546: NULL, C_INTERPOL_LINER, 'M', rec.batch_id, l_ric_code);

Line 7395: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;

7391: PROCEDURE xtr_revl_getprice_bond(
7392: rec IN xtr_revl_rec,
7393: p_bond_clean_price OUT NOCOPY NUMBER) IS
7394: l_bond_issue XTR_DEALS.bond_issue%TYPE;
7395: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;
7396: l_margin XTR_DEALS.margin%TYPE;
7397: l_coupon_action XTR_DEALS.coupon_action%TYPE;
7398: l_side VARCHAR2(1);
7399: l_bond_yield_m NUMBER;

Line 7432: from XTR_BOND_ISSUES

7428: where DEAL_NO = rec.deal_no;
7429:
7430: select RIC_CODE
7431: into l_ric_code
7432: from XTR_BOND_ISSUES
7433: where bond_issue_code = rec.contract_code;
7434:
7435: l_market_set := rec.MARKET_DATA_SET;
7436: xtr_revl_get_mds(l_market_set, rec);

Line 9058: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;

9054: rec IN xtr_revl_rec,
9055: p_stock_price OUT NOCOPY NUMBER) IS
9056:
9057: l_stock_issue XTR_DEALS.bond_issue%TYPE;
9058: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;
9059: l_side VARCHAR2(1);
9060: r_md_in xtr_market_data_p.md_from_set_in_rec_type;
9061: r_md_out xtr_market_data_p.md_from_set_out_rec_type;
9062: r_err_log err_log; -- record type