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 1513: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;

1509: r_fx_rate xtr_revl_fx_rate; -- record type
1510: r_md_in xtr_market_data_p.md_from_set_in_rec_type;
1511: r_md_out xtr_market_data_p.md_from_set_out_rec_type;
1512: l_market_set VARCHAR2(30);
1513: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;
1514: l_dummy NUMBER;
1515: l_dummy1 NUMBER;
1516: l_knock_type XTR_DEALS.knock_type%TYPE;
1517: l_knock_date DATE;

Line 1559: from XTR_BOND_ISSUES

1555: elsif rec.expiry_date <= rec.revldate and rec.status_code = 'EXPIRED' then -- realized
1556: if rec.contract_code is not null then
1557: select RIC_CODE
1558: into l_ric_code
1559: from XTR_BOND_ISSUES
1560: where bond_issue_code = rec.contract_code;
1561: xtr_revl_mds_init(r_md_in, l_market_set, C_SOURCE,
1562: C_BOND_IND, rec.expiry_date, null, rec.currencya, NULL,
1563: NULL, C_INTERPOL_LINER, 'M', rec.batch_id, l_ric_code);

Line 7414: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;

7410: PROCEDURE xtr_revl_getprice_bond(
7411: rec IN xtr_revl_rec,
7412: p_bond_clean_price OUT NOCOPY NUMBER) IS
7413: l_bond_issue XTR_DEALS.bond_issue%TYPE;
7414: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;
7415: l_margin XTR_DEALS.margin%TYPE;
7416: l_coupon_action XTR_DEALS.coupon_action%TYPE;
7417: l_side VARCHAR2(1);
7418: l_bond_yield_m NUMBER;

Line 7451: from XTR_BOND_ISSUES

7447: where DEAL_NO = rec.deal_no;
7448:
7449: select RIC_CODE
7450: into l_ric_code
7451: from XTR_BOND_ISSUES
7452: where bond_issue_code = rec.contract_code;
7453:
7454: l_market_set := rec.MARKET_DATA_SET;
7455: xtr_revl_get_mds(l_market_set, rec);

Line 9077: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;

9073: rec IN xtr_revl_rec,
9074: p_stock_price OUT NOCOPY NUMBER) IS
9075:
9076: l_stock_issue XTR_DEALS.bond_issue%TYPE;
9077: l_ric_code XTR_BOND_ISSUES.ric_code%TYPE;
9078: l_side VARCHAR2(1);
9079: r_md_in xtr_market_data_p.md_from_set_in_rec_type;
9080: r_md_out xtr_market_data_p.md_from_set_out_rec_type;
9081: r_err_log err_log; -- record type