DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on HR_LOOKUPS

Line 1027: FROM hr_lookups

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

Line 1038: FROM hr_lookups

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