APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_BOND_COUPON_DATES

Line 1293: from xtr_bond_coupon_dates

1289: ---------------------------------------------------------------------
1290: cursor TOTAL_FULL_COUPONS (p_issue_code VARCHAR2) is
1291: select count(*)-1, -- Total FULL Coupon
1292: min(coupon_date) -- Odd Coupon Maturity
1293: from xtr_bond_coupon_dates
1294: where bond_issue_code = p_issue_code;
1295:
1296: -------------------------------------------------------------------------------
1297: -- Get Previous Coupon Date and No of Previous Full Coupon for COMPOUND COUPON

Line 1302: from XTR_BOND_COUPON_DATES

1298: -------------------------------------------------------------------------------
1299: cursor PRV_COUPON_DATES is
1300: select max(COUPON_DATE), -- Previous Coupon Date
1301: greatest(count(*)-1,0) -- Previous Full Coupon
1302: from XTR_BOND_COUPON_DATES
1303: where BOND_ISSUE_CODE = l_bond_issue
1304: and COUPON_DATE <= p_end_date;
1305:
1306: ------------------------------------------------

Line 1311: from XTR_BOND_COUPON_DATES

1307: -- Get Next Coupon Date for COMPOUND COUPON
1308: ------------------------------------------------
1309: cursor NXT_COUPON_DATES is
1310: select min(COUPON_DATE) -- Next Coupon Date
1311: from XTR_BOND_COUPON_DATES
1312: where BOND_ISSUE_CODE = l_bond_issue
1313: and COUPON_DATE > p_end_date;
1314:
1315: l_dummy_date DATE;

Line 1573: from XTR_BOND_COUPON_DATES

1569: -----------------------------------------
1570: l_dummy_date := to_date(null);
1571: select nvl(min(COUPON_DATE),p_end_date)
1572: into l_dummy_date
1573: from XTR_BOND_COUPON_DATES
1574: where BOND_ISSUE_CODE = l_bond_issue
1575: and COUPON_DATE > l_deal_start;
1576: if p_end_date <= l_dummy_date then
1577: onc_det.first_trans_flag := 'Y';