APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_BOND_ALLOC_DETAILS

Line 883: xtr_bond_alloc_details b

879: and ((a.deal_type <> 'BOND' and a.status_code <> 'CANCELLED')
880: or (a.deal_type = 'BOND' and a.status_code not in ('CANCELLED','CLOSED')
881: and a.deal_subtype in ('BUY','ISSUE'))
882: and a.deal_number not in (select deal_no from
883: xtr_bond_alloc_details b
884: where b.deal_no = d.deal_no
885: and b.face_value = d.maturity_amount
886: and b.cross_ref_start_date = d.start_date)) -- bug 5490311
887: -----------------------------

Line 951: xtr_bond_alloc_details b

947: and c.action_code = 'POS'
948: and c.amount_type in ('SLDISC','SLPREM')))))
949: and a.status_code not in ('CANCELLED', 'CLOSED')
950: and a.deal_no not in (select deal_no from
951: xtr_bond_alloc_details b
952: where b.deal_no = a.deal_no
953: and b.face_value = a.maturity_amount
954: and b.cross_ref_start_date = a.start_date) -- bug 5490311
955: -------------------------------

Line 1162: from XTR_BOND_ALLOC_DETAILS

1158: select decode(l_trade_settle,'TRADE',cross_ref_deal_date,cross_ref_start_date) resale_recognition_date,
1159: front_end_prem_disc,
1160: face_value,
1161: cross_ref_no
1162: from XTR_BOND_ALLOC_DETAILS
1163: where deal_no = l_deal_nos
1164: and decode(l_trade_settle,'TRADE',cross_ref_deal_date,cross_ref_start_date) <= p_end_date
1165: and (deal_no,cross_ref_no) not in (select deal_no,trans_no
1166: from xtr_accrls_amort

Line 1179: from XTR_BOND_ALLOC_DETAILS b,

1175: select b.back_end_interest,
1176: b.cross_ref_start_date,
1177: b.face_value,
1178: d.coupon_action -- 2422480 added
1179: from XTR_BOND_ALLOC_DETAILS b,
1180: XTR_DEALS d
1181: where b.deal_no = l_deal_nos
1182: and d.deal_no = l_deal_nos
1183: and b.cross_ref_start_date between l_elig_resale_start and l_elig_resale_end;

Line 1354: from XTR_BOND_ALLOC_DETAILS

1350: -- 2753088,2751078 - Get total resale face value up to given date
1351: ------------------------------------------------------------------
1352: cursor TOTAL_RESALE_FACE_VALUE (p_deal_no NUMBER, p_date DATE) is
1353: select nvl(sum(face_value),0)
1354: from XTR_BOND_ALLOC_DETAILS
1355: where deal_no = p_deal_no
1356: and cross_ref_start_date <= p_date;
1357:
1358: -----------------------------------------------------------------------------------------

Line 3073: from XTR_BOND_ALLOC_DETAILS

3069: -- (3) = Sum all back end interest
3070: -----------------------------------------------------------------------------
3071: select nvl(sum(back_end_interest),0)
3072: into l_sum_backend_int
3073: from XTR_BOND_ALLOC_DETAILS
3074: where deal_no = onc_det.deal_nos
3075: and cross_ref_start_date <= period_end
3076: and cross_ref_start_date >= period_start; -- Bug 4613248 Added the condition
3077: