APPS.PAY_US_TAX_BALANCE_PERF dependencies on HR_LOOKUPS

Line 165: FROM hr_lookups

161: -- Check that inputs based on lookups are valid
162: --
163: SELECT count(*)
164: INTO l_valid
165: FROM hr_lookups
166: WHERE lookup_type = 'US_TAX_BALANCE_CATEGORY'
167: AND lookup_code = p_tax_balance_category;
168: --
169: IF l_valid = 0 THEN

Line 176: FROM hr_lookups

172: END IF;
173: --
174: SELECT count(*)
175: INTO l_valid
176: FROM hr_lookups
177: WHERE lookup_type = 'US_TAX_TYPE'
178: AND lookup_code = p_tax_type;
179: --
180: IF l_valid = 0 THEN