892: ) return varchar2 is
893: --
894: cursor csr_lookup is
895: select name
896: from fnd_currencies_vl
897: where currency_code = p_currency_code;
898:
899: --
900: v_name fnd_currencies_vl.name%TYPE := null;
896: from fnd_currencies_vl
897: where currency_code = p_currency_code;
898:
899: --
900: v_name fnd_currencies_vl.name%TYPE := null;
901: begin
902: if p_currency_code is not null then
903: --
904: open csr_lookup;