DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_COUNTIES

Line 1882: pay_us_counties puc

1878: puc.county_name||','||pus.state_abbrev jurisdiction_name
1879: FROM pay_run_balances prb,
1880: per_assignments_f paf,
1881: pay_us_states pus,
1882: pay_us_counties puc
1883: WHERE paf.person_id = IN_person_id
1884: AND paf.effective_start_date <= IN_as_of_date
1885: AND paf.effective_end_date >= IN_start_date
1886: AND prb.assignment_id = paf.assignment_id

Line 2040: pay_us_counties puc

2036: puc.county_name||','||pus.state_abbrev jurisdiction_name
2037: FROM pay_us_emp_county_tax_rules_f pes,
2038: per_assignments_f paf,
2039: pay_us_states pus,
2040: pay_us_counties puc
2041: WHERE pes.assignment_id = paf.assignment_id
2042: AND pes.state_code = pus.state_code
2043: AND pes.county_code = puc.county_code
2044: AND pes.state_code = puc.state_code