1023: if p_tax_balance_category <> 'NONE' then
1024:
1025: SELECT count(0)
1026: INTO l_valid
1027: FROM hr_lookups
1028: WHERE lookup_type = 'US_TAX_BALANCE_CATEGORY'
1029: AND lookup_code = p_tax_balance_category;
1030: --
1031: IF l_valid = 0 THEN
1034: END IF;
1035: --
1036: SELECT count(0)
1037: INTO l_valid
1038: FROM hr_lookups
1039: WHERE lookup_type = 'US_TAX_TYPE'
1040: AND lookup_code = p_tax_type;
1041: --
1042: IF l_valid = 0 THEN