DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_CITY_NAMES

Line 1908: pay_us_city_names pun

1904: pun.city_name||','||pus.state_abbrev jurisdiction_name
1905: FROM pay_run_balances prb,
1906: per_assignments_f paf,
1907: pay_us_states pus,
1908: pay_us_city_names pun
1909: WHERE paf.person_id = IN_person_id
1910: AND paf.effective_start_date <= IN_as_of_date
1911: AND paf.effective_end_date >= IN_start_date
1912: AND paf.assignment_id = prb.assignment_id

Line 2085: pay_us_city_names pun

2081: pun.city_name||','||pus.state_abbrev jurisdiction_name
2082: FROM pay_us_emp_city_tax_rules_f pes,
2083: per_assignments_f paf,
2084: pay_us_states pus,
2085: pay_us_city_names pun
2086: WHERE pes.assignment_id = paf.assignment_id
2087: AND pes.state_code = pus.state_code
2088: AND pes.state_code = pun.state_code
2089: AND pes.county_code = pun.county_code