DBA Data[Home] [Help]

APPS.XTR_EXP_SUMM_P dependencies on XTR_CURRENCY_CROSS_RATES

Line 855: FROM XTR_CURRENCY_CROSS_RATES

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