DBA Data[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_EMP_FED_TAX_RULES_V

Line 5466: , PAY_US_EMP_FED_TAX_RULES_V peft

5462: /*
5463: cursor csr_filing_status(p_assignment number, p_state varchar2) is
5464: select hrl.lookup_code, peft.withholding_allowances
5465: from HR_LOOKUPS hrl
5466: , PAY_US_EMP_FED_TAX_RULES_V peft
5467: where hrl.lookup_type = 'US_FS_'||p_state
5468: and upper(hrl.meaning) = decode(
5469: upper(substr(peft.filing_status,1,7)),
5470: 'MARRIED',

Line 5478: , PAY_US_EMP_FED_TAX_RULES_V peft

5474: */
5475: cursor csr_filing_status(p_assignment number, p_state varchar2) is
5476: select flv.lookup_code, peft.withholding_allowances
5477: from FND_LOOKUP_VALUES flv
5478: , PAY_US_EMP_FED_TAX_RULES_V peft
5479: where flv.lookup_type = 'US_FS_'||p_state
5480: and upper(flv.meaning) = decode(
5481: upper(substr(peft.filing_status,1,7)),
5482: 'MARRIED',