[Home] [Help]
95:
96: CURSOR Cur_get_exchange_rate(V_currency VARCHAR2) IS
97: SELECT ex.exchange_rate, ex.mul_div_sign,
98: ex.exchange_rate_date
99: FROM gl_xchg_rte ex,
100: gl_srce_mst src
101: WHERE ex.to_currency_code = X_cust_details.billing_currency and
102: ex.from_currency_code = V_currency and
103: ex.exchange_rate_date <= X_cust_details.order_date and