6552: open x_currency for
6553: select c.currency_code
6554: , c.name currency_name
6555: , c.precision
6556: from fnd_currencies_vl c
6557: where c.currency_flag='Y'
6558: and c.enabled_flag='Y'
6559: and trunc(nvl(c.start_date_active,sysdate))<=trunc(sysdate)
6560: and trunc(nvl(c.end_date_active,sysdate+1))>trunc(sysdate)