APPS.XTR_RESET_BOND_RATE dependencies on FND_DATE

Line 57: and b.rate_fixing_date between fnd_date.canonical_to_date(p_rateset_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)
59: and c.benchmark_rate is not null
60: and c.benchmark_rate = nvl(p_bench_mark, c.benchmark_rate)
61: and c.calc_type in ('FL IRREGULAR','FL REGULAR')

Line 58: and fnd_date.canonical_to_date(p_rateset_to)

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)
59: and c.benchmark_rate is not null
60: and c.benchmark_rate = nvl(p_bench_mark, c.benchmark_rate)
61: and c.calc_type in ('FL IRREGULAR','FL REGULAR')
62: ORDER BY b.bond_issue_code,b.rate_fixing_date,b.coupon_date;

Line 77: and b.rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)

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:
80: cursor C_SUBSEQ_BOND_DETAILS IS
81: select a.rate_fixing_date,

Line 78: and fnd_date.canonical_to_date(p_rateset_to) );

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:
80: cursor C_SUBSEQ_BOND_DETAILS IS
81: select a.rate_fixing_date,
82: a.coupon_date

Line 94: if fnd_date.canonical_to_date(p_rateset_from) > sysdate then

90: BEGIN
91:
92: retcode := 0;
93:
94: if fnd_date.canonical_to_date(p_rateset_from) > sysdate then
95: retcode := 2;
96: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_FROM');
97: l_buf := FND_MESSAGE.GET;
98: fnd_file.put_line(fnd_file.log, l_buf);

Line 101: if fnd_date.canonical_to_date(p_rateset_to) > sysdate then

97: l_buf := FND_MESSAGE.GET;
98: fnd_file.put_line(fnd_file.log, l_buf);
99: end if;
100:
101: if fnd_date.canonical_to_date(p_rateset_to) > sysdate then
102: retcode := 2;
103: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_TO');
104: l_buf := FND_MESSAGE.GET;
105: fnd_file.put_line(fnd_file.log, l_buf);