DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 2037: FROM pay_us_emp_county_tax_rules_f pes,

2033: IN_start_date IN DATE,
2034: IN_as_of_date IN DATE) IS
2035: SELECT DISTINCT pes.jurisdiction_code,
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

Line 2174: FROM pay_us_emp_county_tax_rules_f pes,

2170: SELECT DISTINCT
2171: pes.state_code||'-'||pes.school_district_code jurisdiction_code,
2172: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
2173: pes.jurisdiction_code reg_jurisdiction_cd
2174: FROM pay_us_emp_county_tax_rules_f pes,
2175: per_assignments_f paf,
2176: pay_us_states pus,
2177: pay_us_county_school_dsts psd
2178: WHERE pes.assignment_id = paf.assignment_id