DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 2082: FROM pay_us_emp_city_tax_rules_f pes,

2078: IN_as_of_date IN DATE) IS
2079: SELECT DISTINCT
2080: pes.jurisdiction_code,
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

Line 2131: FROM pay_us_emp_city_tax_rules_f pes,

2127: SELECT DISTINCT
2128: pes.state_code||'-'||pes.school_district_code jurisdiction_code,
2129: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
2130: pes.jurisdiction_code reg_jurisdiction_cd
2131: FROM pay_us_emp_city_tax_rules_f pes,
2132: per_assignments_f paf,
2133: pay_us_states pus,
2134: pay_us_city_school_dsts psd
2135: WHERE pes.assignment_id = paf.assignment_id