956: if p_tax_balance_category <> 'NONE' then
957:
958: SELECT count(0)
959: INTO l_valid
960: FROM hr_lookups
961: WHERE lookup_type = 'US_TAX_BALANCE_CATEGORY'
962: AND lookup_code = p_tax_balance_category;
963: --
964: IF l_valid = 0 THEN
967: END IF;
968: --
969: SELECT count(0)
970: INTO l_valid
971: FROM hr_lookups
972: WHERE lookup_type = 'US_TAX_TYPE'
973: AND lookup_code = p_tax_type;
974: --
975: IF l_valid = 0 THEN