DBA Data[Home] [Help]

APPS.XTR_FPS2_P dependencies on XTR_INTEREST_PERIOD_RATES_V

Line 1770: from XTR_INTEREST_PERIOD_RATES_V

1766: /* with rateset day adjustment. */
1767: /*-------------------------------------------------*/
1768: cursor curr_bench_rate is
1769: select nvl(BID_RATE,OFFER_RATE)
1770: from XTR_INTEREST_PERIOD_RATES_V
1771: where UNIQUE_PERIOD_ID = p_ric_code
1772: and trunc(rate_date) between (p_rate_date-nvl(p_rateset_adj,0)) -- Bug 5259621
1773: and p_rate_date -- Bug 5259621
1774: and (bid_rate is not null or offer_rate is not null)