APPS.XTR_MM_COVERS dependencies on XTR_BOND_COUPON_DATES

Line 1386: from XTR_BOND_COUPON_DATES --------------------------------------------------------

1382: --
1383: cursor PRV_COUPON_DATES is
1384: select max(COUPON_DATE), --------------------------------------------------------
1385: min(COUPON_DATE), greatest(count(*)-1,0) -- COMPOUND COUPON: first coupon date, prev full coupon
1386: from XTR_BOND_COUPON_DATES --------------------------------------------------------
1387: where BOND_ISSUE_CODE = p_bond_issue_code
1388: and COUPON_DATE <= p_settlement_date;
1389:
1390: cursor NXT_COUPON_DATES is

Line 1392: from XTR_BOND_COUPON_DATES

1388: and COUPON_DATE <= p_settlement_date;
1389:
1390: cursor NXT_COUPON_DATES is
1391: select min(COUPON_DATE),nvl(count(COUPON_DATE),0)
1392: from XTR_BOND_COUPON_DATES
1393: where BOND_ISSUE_CODE = p_bond_issue_code
1394: and COUPON_DATE > p_settlement_date;
1395:
1396: -----------------------------------------------------------------------------------------------------

Line 1399: from xtr_bond_coupon_dates

1395:
1396: -----------------------------------------------------------------------------------------------------
1397: cursor TOTAL_FULL_COUPONS (p_issue_code VARCHAR2) is -- COMPOUND COUPON: Count number of full coupons
1398: select count(*)-1
1399: from xtr_bond_coupon_dates
1400: where bond_issue_code = p_issue_code;
1401: -----------------------------------------------------------------------------------------------------
1402: --bug 2804548
1403: cursor get_benchmark_rate(p_settlement_date DATE,p_bond_issue_code VARCHAR2) is

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 1409: from XTR_BOND_COUPON_DATES

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
1410: where BOND_ISSUE_CODE = p_bond_issue_code
1411: and COUPON_DATE > p_settlement_date);
1412:
1413: FUNCTION ROUND_P(p_num IN NUMBER) RETURN NUMBER IS

Line 1525: from xtr_bond_coupon_dates

1521: --------------------------------------
1522: if l_odd_coupon_maturity is null and l_calc_type = 'COMPOUND COUPON' then
1523: select min(COUPON_DATE)
1524: into l_odd_coupon_maturity
1525: from xtr_bond_coupon_dates
1526: where bond_issue_code = p_bond_issue_code;
1527: end if;
1528:
1529: ----------------------------------------------------------------------------------

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: --

Line 2430: from xtr_bond_coupon_dates

2426: --
2427: cursor GET_LAST_COUPON_DATE(p_bond_issue_code VARCHAR2,
2428: p_next_coupon_date DATE) is
2429: select max(coupon_date)
2430: from xtr_bond_coupon_dates
2431: where bond_issue_code = p_bond_issue_code
2432: and coupon_date < p_next_coupon_date;
2433: --
2434: cursor get_deal_info(p_deal_no NUMBER,p_trans_no NUMBER) is

Line 2628: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt

2624:
2625: cursor check_coupon_rate_reset(p_deal_no NUMBER,
2626: p_trans_no NUMBER) is
2627: select count(*)
2628: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt
2629: where rt.deal_number=p_deal_no
2630: and rt.transaction_number=p_trans_no
2631: and d.deal_no=rt.deal_number
2632: and bc.bond_issue_code=d.bond_issue

Line 2638: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt

2634: and bc.rate_update_on 2635:
2636: cursor check_coupon_rate_reset_all(p_deal_no NUMBER) is
2637: select count(*)
2638: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt
2639: where d.deal_no=p_deal_no
2640: and d.deal_no=rt.deal_number
2641: and bc.bond_issue_code=d.bond_issue
2642: and bc.coupon_date=rt.maturity_date