APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_US_STATES

Line 1113: select hl.lookup_code, peft.withholding_allowances -- Bug 3354046: Table pay_us_states is added to remove 2 MJC and FTS on table

1109: -- This cursor gets the filing status and exemptions from the federal record
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)

Line 1116: pay_us_states pus

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)),
1120: 'MARRIED',

Line 2150: from pay_us_states

2146:
2147: /* Get state abbreviation */
2148: CURSOR csr_state_abbrev is
2149: select state_abbrev
2150: from pay_us_states
2151: where state_code = fnd_number.canonical_to_number(substr(P_jurisdiction,1,2));
2152:
2153: /* Gets the county name */
2154: