DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on HR_LOOKUPS

Line 960: FROM hr_lookups

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

Line 971: FROM hr_lookups

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