DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_COUNTIES

Line 1397: pay_us_counties puc

1393: puc.county_name||','||pus.state_abbrev jurisdiction_name
1394: FROM pay_run_balances prb,
1395: per_assignments_f paf,
1396: pay_us_states pus,
1397: pay_us_counties puc
1398: WHERE paf.person_id = IN_person_id
1399: AND paf.effective_start_date <= IN_as_of_date
1400: AND paf.effective_end_date >= IN_start_date
1401: AND prb.assignment_id = paf.assignment_id

Line 1552: pay_us_counties puc

1548: puc.county_name||','||pus.state_abbrev jurisdiction_name
1549: FROM pay_us_emp_county_tax_rules_f pes,
1550: per_assignments_f paf,
1551: pay_us_states pus,
1552: pay_us_counties puc
1553: WHERE pes.assignment_id = paf.assignment_id
1554: AND pes.state_code = pus.state_code
1555: AND pes.county_code = puc.county_code
1556: AND pes.state_code = puc.state_code