[Home] [Help]
912: AND pugu.assignment_id = p_assignment_id
913: AND EXISTS
914: (SELECT NULL
915: FROM pay_us_emp_city_tax_rules_f pect,
916: pay_us_city_school_dsts pcsd,
917: pay_us_modified_geocodes pumg
918: WHERE pect.assignment_id = p_assignment_id
919: AND pect.jurisdiction_code = pumg.state_code||'-'||pumg.county_code||'-'||pumg.old_city_code
920: AND pugu.description = substr(pumg.city_name,8,6)