[Home] [Help]
851: p_contra_ccy VARCHAR2,
852: p_date DATE) RETURN NUMBER IS
853: cursor get_cross is
854: SELECT BID_RATE
855: FROM XTR_CURRENCY_CROSS_RATES
856: WHERE CURRENCY_FIRST=p_base_ccy
857: and CURRENCY_SECOND=p_contra_ccy
858: and rate_date in(select max(rate_date)
859: from XTR_spot_rates