APPS.XTR_MM_COVERS dependencies on XTR_BOND_ISSUES

Line 1380: from XTR_BOND_ISSUES_V

1376: COMMENCE_DATE,nvl(NO_OF_COUPONS_PER_YEAR,0),
1377: nvl(ACCRUED_INT_YEAR_CALC_BASIS,YEAR_CALC_TYPE),MATURITY_DATE,
1378: price_rounding,price_round_type,yield_rounding,yield_round_type,
1379: calc_rounding, rounding_type
1380: from XTR_BOND_ISSUES_V
1381: where BOND_ISSUE_CODE = p_bond_issue_code;
1382: --
1383: cursor PRV_COUPON_DATES is
1384: select max(COUPON_DATE), --------------------------------------------------------

Line 1405: from xtr_bond_coupon_dates c, xtr_bond_issues i

1401: -----------------------------------------------------------------------------------------------------
1402: --bug 2804548
1403: cursor get_benchmark_rate(p_settlement_date DATE,p_bond_issue_code VARCHAR2) is
1404: select c.rate, i.float_margin
1405: from xtr_bond_coupon_dates c, xtr_bond_issues i
1406: where c.bond_issue_code=p_bond_issue_code
1407: and c.bond_issue_code=i.bond_issue_code
1408: and c.coupon_date=(select min(COUPON_DATE)
1409: from XTR_BOND_COUPON_DATES

Line 2422: from xtr_bond_issues i, xtr_bond_coupon_dates c

2418: i.maturity_date,
2419: i.year_calc_type,
2420: i.commence_date,
2421: i.calc_type
2422: from xtr_bond_issues i, xtr_bond_coupon_dates c
2423: where i.bond_issue_code = p_bond_issue_code
2424: and c.bond_issue_code=i.bond_issue_code
2425: and c.coupon_date=p_coupon_date;
2426: --