DBA Data[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_EMP_FED_TAX_RULES_V

Line 5542: , PAY_US_EMP_FED_TAX_RULES_V peft

5538: /*
5539: cursor csr_filing_status(p_assignment number, p_state varchar2) is
5540: select hrl.lookup_code, peft.withholding_allowances
5541: from HR_LOOKUPS hrl
5542: , PAY_US_EMP_FED_TAX_RULES_V peft
5543: where hrl.lookup_type = 'US_FS_'||p_state
5544: and upper(hrl.meaning) = decode(
5545: upper(substr(peft.filing_status,1,7)),
5546: 'MARRIED',

Line 5554: , PAY_US_EMP_FED_TAX_RULES_V peft

5550: */
5551: cursor csr_filing_status(p_assignment number, p_state varchar2) is
5552: select flv.lookup_code, peft.withholding_allowances
5553: from FND_LOOKUP_VALUES flv
5554: , PAY_US_EMP_FED_TAX_RULES_V peft
5555: where flv.lookup_type = 'US_FS_'||p_state
5556: and upper(flv.meaning) = decode(
5557: upper(substr(peft.filing_status,1,7)),
5558: 'MARRIED',