265: --
266: /* cursor csr_filing_status is
267: select hrl.lookup_code, peft.withholding_allowances
268: from HR_LOOKUPS hrl
269: , PAY_US_EMP_FED_TAX_RULES_V peft
270: where hrl.lookup_type = 'US_FS_'||p_state_code
271: and upper(hrl.meaning) = decode(
272: upper(substr(peft.filing_status,1,7)),
273: 'MARRIED',
278:
279: cursor csr_filing_status is
280: select flv.lookup_code, peft.withholding_allowances
281: from FND_LOOKUP_VALUES flv
282: , PAY_US_EMP_FED_TAX_RULES_V peft
283: where flv.lookup_type = 'US_FS_'||p_state_code
284: and upper(flv.meaning) = decode(
285: upper(substr(peft.filing_status,1,7)),
286: 'MARRIED',