APPS.XTR_COF_P dependencies on XTR_BOND_ISSUES

Line 82: L_CALC_TYPE XTR_BOND_ISSUES.calc_type%TYPE;

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;
86: L_CONVERT_RATE NUMBER;

Line 1025: L_CALC_TYPE XTR_BOND_ISSUES.calc_type%TYPE;

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;
1029: L_CONVERT_RATE 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 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