DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 1549: FROM pay_us_emp_county_tax_rules_f pes,

1545: IN_start_date IN DATE,
1546: IN_as_of_date IN DATE) IS
1547: SELECT DISTINCT pes.jurisdiction_code,
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

Line 1686: FROM pay_us_emp_county_tax_rules_f pes,

1682: SELECT DISTINCT
1683: pes.state_code||'-'||pes.school_district_code jurisdiction_code,
1684: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1685: pes.jurisdiction_code reg_jurisdiction_cd
1686: FROM pay_us_emp_county_tax_rules_f pes,
1687: per_assignments_f paf,
1688: pay_us_states pus,
1689: pay_us_county_school_dsts psd
1690: WHERE pes.assignment_id = paf.assignment_id