71: -- Temp Variable
72: l_kle_id NUMBER;
73:
74: -- Multi Currency Compliance
75: l_currency_code okl_ext_sell_invs_b.currency_code%type;
76: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
77: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
78: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
79:
72: l_kle_id NUMBER;
73:
74: -- Multi Currency Compliance
75: l_currency_code okl_ext_sell_invs_b.currency_code%type;
76: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
77: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
78: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
79:
80: CURSOR l_curr_conv_csr( cp_khr_id NUMBER ) IS
73:
74: -- Multi Currency Compliance
75: l_currency_code okl_ext_sell_invs_b.currency_code%type;
76: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
77: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
78: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
79:
80: CURSOR l_curr_conv_csr( cp_khr_id NUMBER ) IS
81: SELECT currency_code
74: -- Multi Currency Compliance
75: l_currency_code okl_ext_sell_invs_b.currency_code%type;
76: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
77: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
78: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
79:
80: CURSOR l_curr_conv_csr( cp_khr_id NUMBER ) IS
81: SELECT currency_code
82: ,currency_conversion_type