eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_COF_P dependencies on XTR_DEALS

Line 81: L_CALC_BASIS XTR_DEALS.calc_basis%TYPE;

77: L_NO_OF_DAYS_OUT NUMBER;
78: L_YEAR_BASIS_IN NUMBER;
79: L_YEAR_BASIS_OUT NUMBER;
80: L_YIELD_RATE NUMBER;
81: L_CALC_BASIS XTR_DEALS.calc_basis%TYPE;
82: L_CALC_TYPE XTR_BOND_ISSUES.calc_type%TYPE;
83: L_COUPON_RATE NUMBER;
84: L_MATURITY_AMT NUMBER;
85: L_CONSIDERATION NUMBER;

Line 1024: L_CALC_BASIS XTR_DEALS.calc_basis%TYPE;

1020: L_NO_OF_DAYS_OUT NUMBER;
1021: L_YEAR_BASIS_IN NUMBER;
1022: L_YEAR_BASIS_OUT NUMBER;
1023: L_YIELD_RATE NUMBER;
1024: L_CALC_BASIS XTR_DEALS.calc_basis%TYPE;
1025: L_CALC_TYPE XTR_BOND_ISSUES.calc_type%TYPE;
1026: L_COUPON_RATE NUMBER;
1027: L_MATURITY_AMT NUMBER;
1028: L_CONSIDERATION NUMBER;

Line 1172: from xtr_deals D, xtr_bond_issues B

1168:
1169:
1170: cursor get_bond_calc is
1171: select b.calc_type, d.coupon_rate, d.maturity_amount, d.start_amount
1172: from xtr_deals D, xtr_bond_issues B
1173: where d.bond_issue = b.bond_issue_code
1174: and d.deal_no = P_DEAL_NUMBER;
1175:
1176: cursor get_bond_resale is

Line 1186: from xtr_deals

1182: -- bug 4539511
1183:
1184: cursor get_bond_maturity_date is
1185: Select maturity_date
1186: from xtr_deals
1187: where deal_no = p_deal_number
1188: and deal_type = 'BOND'
1189: and maturity_date <= P_AS_AT_DATE;
1190:

Line 2261: from XTR_DEALS a

2257: a.start_amount,
2258: -- Added for Interest Override feature
2259: -- But FX is always populate null value to day_count_type
2260: a.day_count_type
2261: from XTR_DEALS a
2262: where a.deal_type ='FX'
2263: and a.status_code <> 'CANCELLED'
2264: and a.deal_date <= l_date
2265: and nvl(a.start_date,l_date+1) > l_date

Line 2301: from XTR_DEALS a

2297: a.maturity_amount,
2298: a.start_amount,
2299: -- Added for Interest Override feature
2300: a.day_count_type
2301: from XTR_DEALS a
2302: where a.deal_type ='BOND'
2303: and a.deal_subtype in ('BUY', 'ISSUE')
2304: and a.status_code ='CURRENT'
2305: and a.start_date <=l_date

Line 2341: from XTR_DEALS a

2337: a.maturity_amount,
2338: a.start_amount,
2339: -- Added for the Interest Override feature
2340: a.day_count_type
2341: from XTR_DEALS a
2342: where a.deal_type ='BOND'
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

Line 2346: from XTR_DEALS d,

2342: where a.deal_type ='BOND'
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)

Line 2435: XTR_DEALS d

2431: a.first_transaction_flag,
2432: d.day_count_type
2433: from XTR_ROLLOVER_TRANSACTIONS a,
2434: -- Added for Interest Override feature
2435: XTR_DEALS d
2436: where a.deal_type in('TMM','RTMM')
2437: and a.start_date <=l_date
2438: and a.maturity_date >l_date
2439: and a.status_code='CURRENT'

Line 2465: XTR_DEALS d

2461: a.first_transaction_flag,
2462: d.day_count_type
2463: from XTR_ROLLOVER_TRANSACTIONS a,
2464: -- Added for Interest Override feature
2465: XTR_DEALS d
2466: where a.deal_type ='ONC'
2467: and a.start_date <=l_date
2468: and nvl(a.maturity_date,l_date+1) >l_date
2469: and a.interest_rate is not null

Line 2496: XTR_DEALS d

2492: a.first_transaction_flag,
2493: d.day_count_type
2494: from XTR_ROLLOVER_TRANSACTIONS a,
2495: -- Added for Interest Override feature
2496: XTR_DEALS d
2497: where a.deal_type ='NI'
2498: and a.deal_subtype in ('BUY', 'ISSUE')
2499: and a.start_date <=l_date
2500: and nvl(a.ni_reneg_date,a.maturity_date) >l_date

Line 2522: from xtr_deals

2518: where currency = L_CURRENCY;
2519: --
2520: cursor get_calc_basis is
2521: select calc_basis
2522: from xtr_deals
2523: where deal_no=L_DEAL_NUMBER;
2524:
2525: cursor get_bond_type is
2526: select b.year_calc_type, b.calc_type

Line 2527: from XTR_DEALS A, XTR_BOND_ISSUES B

2523: where deal_no=L_DEAL_NUMBER;
2524:
2525: cursor get_bond_type is
2526: select b.year_calc_type, b.calc_type
2527: from XTR_DEALS A, XTR_BOND_ISSUES B
2528: where a.bond_issue = b.bond_issue_code
2529: and a.deal_no = D.DEAL_NUMBER;
2530:
2531: cursor chk_date_exits is

Line 2854: /* p_deal_no : XTR_DEALS.deal_no */

2850: /*******************************************************************************/
2851: /* This procedure is to calculate BOND yield rate based on ACTUAL/365. It is */
2852: /* called by XTR_COF_P.SNAPSHOT_COST_OF_FUND and trigger XTR_AI_DEALS_T */
2853: /* and XTR_AU_DEALS_T. It inputs the following information: */
2854: /* p_deal_no : XTR_DEALS.deal_no */
2855: /* p_maturity_amt : XTR_DEALS.maturity_amount */
2856: /* p_consideration: XTR_DEALS.start_amount */
2857: /* p_coupon_rate : XTR_DEALS.coupon_rate */
2858: /* p_start_date : XTR_DEALS.start_date */

Line 2855: /* p_maturity_amt : XTR_DEALS.maturity_amount */

2851: /* This procedure is to calculate BOND yield rate based on ACTUAL/365. It is */
2852: /* called by XTR_COF_P.SNAPSHOT_COST_OF_FUND and trigger XTR_AI_DEALS_T */
2853: /* and XTR_AU_DEALS_T. It inputs the following information: */
2854: /* p_deal_no : XTR_DEALS.deal_no */
2855: /* p_maturity_amt : XTR_DEALS.maturity_amount */
2856: /* p_consideration: XTR_DEALS.start_amount */
2857: /* p_coupon_rate : XTR_DEALS.coupon_rate */
2858: /* p_start_date : XTR_DEALS.start_date */
2859: /* p_maturity_date: XTR_DEALS.maturity_date */

Line 2856: /* p_consideration: XTR_DEALS.start_amount */

2852: /* called by XTR_COF_P.SNAPSHOT_COST_OF_FUND and trigger XTR_AI_DEALS_T */
2853: /* and XTR_AU_DEALS_T. It inputs the following information: */
2854: /* p_deal_no : XTR_DEALS.deal_no */
2855: /* p_maturity_amt : XTR_DEALS.maturity_amount */
2856: /* p_consideration: XTR_DEALS.start_amount */
2857: /* p_coupon_rate : XTR_DEALS.coupon_rate */
2858: /* p_start_date : XTR_DEALS.start_date */
2859: /* p_maturity_date: XTR_DEALS.maturity_date */
2860: /* p_year_basis : year basis (365 or 360) */

Line 2857: /* p_coupon_rate : XTR_DEALS.coupon_rate */

2853: /* and XTR_AU_DEALS_T. It inputs the following information: */
2854: /* p_deal_no : XTR_DEALS.deal_no */
2855: /* p_maturity_amt : XTR_DEALS.maturity_amount */
2856: /* p_consideration: XTR_DEALS.start_amount */
2857: /* p_coupon_rate : XTR_DEALS.coupon_rate */
2858: /* p_start_date : XTR_DEALS.start_date */
2859: /* p_maturity_date: XTR_DEALS.maturity_date */
2860: /* p_year_basis : year basis (365 or 360) */
2861: /* p_disc_prem : discount or premium */

Line 2858: /* p_start_date : XTR_DEALS.start_date */

2854: /* p_deal_no : XTR_DEALS.deal_no */
2855: /* p_maturity_amt : XTR_DEALS.maturity_amount */
2856: /* p_consideration: XTR_DEALS.start_amount */
2857: /* p_coupon_rate : XTR_DEALS.coupon_rate */
2858: /* p_start_date : XTR_DEALS.start_date */
2859: /* p_maturity_date: XTR_DEALS.maturity_date */
2860: /* p_year_basis : year basis (365 or 360) */
2861: /* p_disc_prem : discount or premium */
2862: /* p_yield_rate : output rate as simple, annualized rate */

Line 2859: /* p_maturity_date: XTR_DEALS.maturity_date */

2855: /* p_maturity_amt : XTR_DEALS.maturity_amount */
2856: /* p_consideration: XTR_DEALS.start_amount */
2857: /* p_coupon_rate : XTR_DEALS.coupon_rate */
2858: /* p_start_date : XTR_DEALS.start_date */
2859: /* p_maturity_date: XTR_DEALS.maturity_date */
2860: /* p_year_basis : year basis (365 or 360) */
2861: /* p_disc_prem : discount or premium */
2862: /* p_yield_rate : output rate as simple, annualized rate */
2863: /*******************************************************************************/