APPS.XTR_COF_P dependencies on XTR_BOND_ALLOC_DETAILS

Line 1088: from xtr_bond_alloc_details

1084:
1085: cursor BOND_LAST_PROC_DATE(V_AS_AT_DATE DATE,
1086: V_DEAL_NUMBER NUMBER)is
1087: select cross_ref_start_date, avg_rate_last_processed
1088: from xtr_bond_alloc_details
1089: where deal_no = V_DEAL_NUMBER
1090: and CROSS_REF_START_DATE <= V_AS_AT_DATE
1091: and avg_rate_last_processed is null
1092: order by cross_ref_start_date; -- 4470022

Line 1178: From XTR_BOND_ALLOC_DETAILS

1174: and d.deal_no = P_DEAL_NUMBER;
1175:
1176: cursor get_bond_resale is
1177: Select sum(face_value), max(cross_ref_start_date)
1178: From XTR_BOND_ALLOC_DETAILS
1179: Where deal_no = P_DEAL_NUMBER
1180: and cross_ref_start_date <= P_AS_AT_DATE;
1181:
1182: -- bug 4539511

Line 1433: From XTR_BOND_ALLOC_DETAILS

1429:
1430: -- bug 4470022 Added the following lines
1431: Select sum(face_value)
1432: into l_face_value
1433: From XTR_BOND_ALLOC_DETAILS
1434: Where deal_no = P_DEAL_NUMBER
1435: and cross_ref_start_date <= L_AS_AT_DATE;
1436:
1437: IF l_face_value <> 0 then

Line 1563: Update XTR_BOND_ALLOC_DETAILS

1559: decode(P_DEAL_TYPE, 'FX', 0, abs(L_HCE_INT)));
1560: end if;
1561:
1562: if P_DEAL_TYPE = 'BOND' and l_face_value_sold is not null then
1563: Update XTR_BOND_ALLOC_DETAILS
1564: set avg_rate_last_processed = greatest(nvl(avg_rate_last_processed, L_AS_AT_DATE),
1565: L_AS_AT_DATE)
1566: where deal_no = P_DEAL_NUMBER;
1567: end if;

Line 2347: XTR_BOND_ALLOC_DETAILS R

2343: and a.deal_subtype in ('BUY', 'ISSUE') -- Bond Repurchase Project - 2879858.
2344: and a.status_code ='CURRENT'
2345: and a.deal_no in (select distinct d.deal_no
2346: from XTR_DEALS d,
2347: XTR_BOND_ALLOC_DETAILS R
2348: where d.deal_no = r.deal_no
2349: and d.maturity_date <= l_date
2350: and nvl(r.avg_rate_last_processed, r.cross_ref_start_date)
2351: < d.maturity_date);

Line 2538: from xtr_bond_alloc_details

2534: where as_at_date = l_date;
2535:
2536: cursor bond_total_resale is
2537: select sum(face_value), max(cross_ref_start_date)
2538: from xtr_bond_alloc_details
2539: where deal_no = D.DEAL_NUMBER
2540: and CROSS_REF_START_DATE <= l_date;
2541:
2542:

Line 2590: Update XTR_BOND_ALLOC_DETAILS

2586:
2587: OPEN bond_total_resale;
2588: FETCH bond_total_resale into l_total_resale,l_cross_ref_start_date;
2589: if l_total_resale = D.MATURITY_AMOUNT then
2590: Update XTR_BOND_ALLOC_DETAILS
2591: Set avg_rate_last_processed = L_DATE
2592: where deal_no = d.deal_number -- bug 4470022 Added where clause
2593: and cross_ref_start_date = l_cross_ref_start_date;
2594: close bond_total_resale;

Line 2906: FROM xtr_bond_alloc_details

2902: Where deal_number = p_deal_no;
2903:
2904: SELECT COUNT(deal_no)
2905: INTO l_resale_count
2906: FROM xtr_bond_alloc_details
2907: WHERE deal_no=p_deal_no;
2908:
2909: IF l_resale_count>0 AND l_interest <> l_original_amount THEN
2910: l_coupon := l_interest;