APPS.GML_PO_GLDIST dependencies on GL_XCHG_RTE

Line 900: # gl_xchg_rte table. the row selected should be the latest dated

896: # pfrom_currency - the from currency code to select by
897: # Description
898: # Retrieves the exchange rate and mul_div_sign based on the parameters
899: # send in, psource_type _date, pto_currency and pfrom_currency, from
900: # gl_xchg_rte table. the row selected should be the latest dated
901: # row.
902: #
903: ##############################################################################*/
904:

Line 911: FROM gl_xchg_rte ex, gl_srce_mst src

907: RETURN NUMBER AS
908: CURSOR Cur_get_exch_rate IS
909: SELECT ex.exchange_rate , ex.mul_div_sign,
910: ex.exchange_rate_date
911: FROM gl_xchg_rte ex, gl_srce_mst src
912: WHERE ex.to_currency_code = V_default_currency and
913: ex.from_currency_code= V_billing_currency and
914: ex.exchange_rate_date <= V_po_date and
915: ex.rate_type_code = src.rate_type_code and

Line 922: FROM gl_xchg_rte ex, gl_srce_mst src

918:
919: CURSOR Cur_get_exch_rate_inv IS
920: SELECT ex.exchange_rate , ex.mul_div_sign,
921: ex.exchange_rate_date
922: FROM gl_xchg_rte ex, gl_srce_mst src
923: WHERE ex.to_currency_code = V_billing_currency and
924: ex.from_currency_code= V_default_currency and
925: ex.exchange_rate_date <= V_po_date and
926: ex.rate_type_code = src.rate_type_code and