APPS.XTR_RESET_BOND_RATE dependencies on XTR_BOND_COUPON_DATES

Line 25: l_bond_issue_code XTR_BOND_COUPON_DATES.bond_issue_code%TYPE;

21: l_deal_type XTR_DEALS.DEAL_TYPE%TYPE;
22: l_start_date DATE;
23: l_coupon_date DATE;
24: l_ratefix_date DATE;
25: l_bond_issue_code XTR_BOND_COUPON_DATES.bond_issue_code%TYPE;
26: l_bench_mark XTR_BOND_ISSUES.BENCHMARK_RATE%TYPE;
27: l_margin NUMBER;
28: l_new_rate NUMBER;
29: l_rate NUMBER;

Line 53: XTR_BOND_COUPON_DATES b,

49: b.coupon_date,
50: c.benchmark_rate,
51: nvl(c.float_margin,0)
52: FROM
53: XTR_BOND_COUPON_DATES b,
54: XTR_BOND_ISSUES c
55: WHERE b.bond_issue_code = c.bond_issue_code
56: AND b.bond_issue_code = NVL(p_bond_issue_code,b.bond_issue_code)
57: and b.rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)

Line 69: from XTR_BOND_COUPON_DATES a

65:
66:
67: cursor C_ONE_ROW_BOND is
68: select 'Y'
69: from XTR_BOND_COUPON_DATES a
70: where a.bond_issue_code = l_bond_issue_code
71: and a.rate_fixing_date = l_ratefix_date
72: and a.rate_fixing_date < (
73: select max (b.rate_fixing_date)

Line 75: XTR_BOND_COUPON_DATES b

71: and a.rate_fixing_date = l_ratefix_date
72: and a.rate_fixing_date < (
73: select max (b.rate_fixing_date)
74: FROM
75: XTR_BOND_COUPON_DATES b
76: WHERE b.bond_issue_code = l_bond_issue_code
77: and b.rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)
78: and fnd_date.canonical_to_date(p_rateset_to) );
79:

Line 83: from XTR_BOND_COUPON_DATES a

79:
80: cursor C_SUBSEQ_BOND_DETAILS IS
81: select a.rate_fixing_date,
82: a.coupon_date
83: from XTR_BOND_COUPON_DATES a
84: where a.bond_issue_code = l_bond_issue_code
85: and a.rate_fixing_date >= l_ratefix_date
86: Order by a.rate_fixing_date;
87:

Line 533: UPDATE XTR_BOND_COUPON_DATES

529: -- End Added not to show the Transactions with 0 amount
530:
531: BEGIN
532: p_count := 0;
533: UPDATE XTR_BOND_COUPON_DATES
534: SET RATE = p_new_rate
535: WHERE BOND_ISSUE_CODE = p_bond_issue_code
536: AND COUPON_DATE = p_coupon_date;
537: