DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALANCE_PERF dependencies on HR_LOOKUPS

Line 232: FROM hr_lookups

228: -- Check that inputs based on lookups are valid
229: --
230: SELECT count(*)
231: INTO l_valid
232: FROM hr_lookups
233: WHERE lookup_type = 'US_TAX_BALANCE_CATEGORY'
234: AND lookup_code = p_tax_balance_category;
235: --
236: IF l_valid = 0 THEN

Line 243: FROM hr_lookups

239: END IF;
240: --
241: SELECT count(*)
242: INTO l_valid
243: FROM hr_lookups
244: WHERE lookup_type = 'US_TAX_TYPE'
245: AND lookup_code = p_tax_type;
246: --
247: IF l_valid = 0 THEN