1110: -- if needed
1111:
1112: CURSOR csr_filing_status is
1113: select hl.lookup_code, peft.withholding_allowances -- Bug 3354046: Table pay_us_states is added to remove 2 MJC and FTS on table
1114: from hr_lookups hl, -- pay_state_rules(table in def. of view pay_emp_fed_tax_v1)
1115: pay_emp_fed_tax_v1 peft,
1116: pay_us_states pus
1117: where hl.lookup_type = 'US_FS_'||substr(p_jurisdiction,1,2)
1118: and upper(hl.meaning) = decode(
1111:
1112: CURSOR csr_filing_status is
1113: select hl.lookup_code, peft.withholding_allowances -- Bug 3354046: Table pay_us_states is added to remove 2 MJC and FTS on table
1114: from hr_lookups hl, -- pay_state_rules(table in def. of view pay_emp_fed_tax_v1)
1115: pay_emp_fed_tax_v1 peft,
1116: pay_us_states pus
1117: where hl.lookup_type = 'US_FS_'||substr(p_jurisdiction,1,2)
1118: and upper(hl.meaning) = decode(
1119: upper(substr(peft.filing_status,1,7)),