APPS.XTR_CALC_P dependencies on XTR_BOND_COUPON_DATES

Line 426: from xtr_bond_coupon_dates

422: --
423: cursor GET_NEXT_COUPON_DATE is
424: select coupon_date,
425: due_date,rate --bug 2804548
426: from xtr_bond_coupon_dates
427: where bond_issue_code = p_bond_issue_code
428: and coupon_date > l_coupon_date
429: order by coupon_date;
430: --

Line 433: from xtr_bond_coupon_dates

429: order by coupon_date;
430: --
431: cursor GET_LAST_COUPON_DATE is
432: select max(coupon_date)
433: from xtr_bond_coupon_dates
434: where bond_issue_code = p_bond_issue_code
435: and coupon_date < p_next_coupon_date;
436: --
437: cursor FIND_USER is

Line 449: from xtr_bond_coupon_dates

445: where REFERENCE_CODE = p_tax_code;
446: --
447: cursor TOTAL_FULL_COUPONS (p_issue_code VARCHAR2) is
448: select count(*)-1, min(coupon_date)
449: from xtr_bond_coupon_dates
450: where bond_issue_code = p_issue_code;
451:
452: l_no_quasi_coupon NUMBER;
453: l_total_coupon_days NUMBER;

Line 462: from xtr_bond_coupon_dates

458: --bug 2804548
459: cursor get_cpn_info(p_cpn_date DATE,
460: p_bond_issue_code VARCHAR2) is
461: select due_date,rate
462: from xtr_bond_coupon_dates
463: where bond_issue_code=p_bond_issue_code
464: and coupon_date=p_cpn_date;
465:
466: v_due_date DATE;