PROCEDURE LTE_ARXTWLIN_OVRIDE_TCODE_LOV IS
errcode_lov     number;
sqlstat_lov     varchar2(2000) := NULL;
BEGIN

IF JL.g_tax_method = 'LATIN' THEN

  -- Create dynamic LOV
  sqlstat_lov := 
'select vt.vat_tax_id, vt.tax_code ,vt.printed_tax_name, vt.tax_rate, 
decode(vt.tax_type, '||''''||'TAX_GROUP'||''''||',
decode(vt.amount_includes_tax_override, '||''''||'N'||''''||', '
||''''||'DEFAULT'||''''||',vt.amount_includes_tax_flag), 
vt.amount_includes_tax_flag) amount_includes_tax_flag,
vt.amount_includes_tax_override , vt.amount_includes_tax_override
from ar_vat_tax_vl vt
where :parameter.art_trx_date
between vt.start_date and nvl(vt.end_date, :parameter.art_trx_date) and 
vt.enabled_flag = ''Y'' and
vt.tax_class = ''O'' and
vt.displayed_flag = ''Y'' and
vt.set_of_books_id = :ar_world.set_of_books_id
and   (vt.tax_type = '||''''||'VAT'||''''||' or 
(vt.tax_type = '||''''||'TAX_GROUP'||''''||' and exists
           (select '||''''||'X'||''''||'
            from   jl_zz_ar_tx_groups tg
            where  vt.vat_tax_id = tg.group_tax_id
                           and nvl(tg.start_date_active,sysdate) <= sysdate
                           and nvl(tg.end_date_active,sysdate) >= sysdate )))
order by /** show tax groups first **/ 
decode(vt.tax_type, '||''''||'TAX_GROUP'||''''||', 1, 2), vt.tax_code';

END IF;

  IF sqlstat_lov IS NOT NULL THEN
    errcode_lov := populate_group_with_query('AR_TLIN_TAX_CODES', sqlstat_lov);
  END IF;
END LTE_ARXTWLIN_OVRIDE_TCODE_LOV;