APPS.XTR_RESET_BOND_RATE dependencies on XTR_BOND_ISSUES

Line 26: l_bench_mark XTR_BOND_ISSUES.BENCHMARK_RATE%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;
30: l_valid_ok BOOLEAN;

Line 54: XTR_BOND_ISSUES c

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)
58: and fnd_date.canonical_to_date(p_rateset_to)