APPS.XTR_FPS2_P dependencies on FND_DATE

Line 1363: and a.rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)

1359: and a.portfolio_code = NVL(p_portfolio,a.portfolio_code)
1360: and a.currency = NVL(p_currency,a.currency)
1361: and a.deal_number = b.deal_no
1362: and a.rate_fixing_date is not null
1363: and a.rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)
1364: and fnd_date.canonical_to_date(p_rateset_to)
1365: and b.rate_basis is not null
1366: and b.rate_basis = nvl(p_ric_code, b.rate_basis)
1367: and b.STATUS_CODE = 'CURRENT'

Line 1364: and fnd_date.canonical_to_date(p_rateset_to)

1360: and a.currency = NVL(p_currency,a.currency)
1361: and a.deal_number = b.deal_no
1362: and a.rate_fixing_date is not null
1363: and a.rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)
1364: and fnd_date.canonical_to_date(p_rateset_to)
1365: and b.rate_basis is not null
1366: and b.rate_basis = nvl(p_ric_code, b.rate_basis)
1367: and b.STATUS_CODE = 'CURRENT'
1368: order by a.deal_type, a.deal_number,

Line 1384: and rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)

1380: and rate_fixing_date <
1381: (select max(rate_fixing_date)
1382: from xtr_rollover_transactions
1383: where deal_number = l_deal_no
1384: and rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)
1385: and fnd_date.canonical_to_date(p_rateset_to));
1386:
1387: Begin
1388:

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

1381: (select max(rate_fixing_date)
1382: from xtr_rollover_transactions
1383: where deal_number = l_deal_no
1384: and rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)
1385: and fnd_date.canonical_to_date(p_rateset_to));
1386:
1387: Begin
1388:
1389: retcode := 0;

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

1387: Begin
1388:
1389: retcode := 0;
1390: -- Modified Bug 4514808
1391: if fnd_date.canonical_to_date(p_rateset_from) > sysdate then
1392: retcode := 2;
1393: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_FROM');
1394: l_buf := FND_MESSAGE.GET;
1395: fnd_file.put_line(fnd_file.log, l_buf);

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

1393: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_FROM');
1394: l_buf := FND_MESSAGE.GET;
1395: fnd_file.put_line(fnd_file.log, l_buf);
1396: end if;
1397: if fnd_date.canonical_to_date(p_rateset_to) > sysdate then
1398: retcode := 2;
1399: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_TO');
1400: l_buf := FND_MESSAGE.GET;
1401: fnd_file.put_line(fnd_file.log, l_buf);