[Home] [Help]
342: select distinct substr(ppf.full_name,1,40) ,
343: pef.assignment_id ,
344: substr(pef.assignment_number,1,17) ,
345: substr(pgu.description,1,65)
346: from per_people_f ppf,
347: per_assignments_f pef,
348: pay_us_geo_update pgu,
349: pay_patch_status pps
350: where pef.assignment_id = pgu.assignment_id
541:
542: select distinct substr(ppf.full_name,1,40) ,
543: pef.assignment_id ,
544: substr(pef.assignment_number,1,17)
545: from per_people_f ppf,
546: per_assignments_f pef,
547: pay_us_geo_update pgu,
548: pay_patch_status pps
549: where pgu.process_type = 'PERCENTAGE_OVER_100'
726:
727: select distinct substr(ppf.full_name,1,40) ,
728: pef.assignment_id ,
729: substr(pef.assignment_number,1,17)
730: from per_people_f ppf,
731: per_assignments_f pef,
732: pay_us_geo_update pgu,
733: pay_patch_status pps
734: where pgu.process_type = 'MISSING_COUNTY_RECORDS'
913: substr(pgu.table_name ,1,20)
914: from pay_us_modified_geocodes pmod,
915: pay_us_city_names pusc ,
916: pay_patch_status pps,
917: per_people_f ppf,
918: per_assignments_f pef,
919: pay_us_geo_update pgu
920: where pgu.process_type = 'PU'
921: and pef.assignment_id = pgu.assignment_id
1147: substr(pusc.city_name,1,20),
1148: old_juri_code "Old JD",
1149: new_juri_code "New JD",
1150: substr(table_name,1,20)
1151: from per_people_f ppf,
1152: per_assignments_f pef,
1153: pay_us_geo_update pgu,
1154: pay_us_city_names pusc,
1155: pay_patch_status pps
1364: substr(puscn.county_name,1,20),
1365: substr(pust.state_abbrev,1,2),
1366: old_juri_code ,
1367: new_juri_code
1368: from per_people_f ppf,
1369: per_assignments_f pef,
1370: pay_us_geo_update pgu,
1371: pay_us_city_names pusc,
1372: pay_patch_status pps ,
1639: FROM pay_us_modified_geocodes pmod,
1640: pay_us_city_names pucn,
1641: pay_us_emp_city_tax_rules_f ectr,
1642: per_assignments_f paf,
1643: per_people_f ppf
1644: WHERE pmod.process_type = 'P'
1645: AND pmod.state_code = pucn.state_code
1646: AND pmod.county_code = pucn.county_code
1647: AND pmod.new_city_code = pucn.city_code
1663: FROM pay_us_modified_geocodes pmod,
1664: pay_us_city_names pucn,
1665: pay_us_emp_city_tax_rules_f ectr,
1666: per_assignments_f paf,
1667: per_people_f ppf,
1668: hr_s_us_city_names pmod2
1669: WHERE pmod.process_type = 'S'
1670: AND pmod.state_code = pucn.state_code
1671: AND pmod.county_code = pucn.county_code
2026: from pay_patch_status pps,
2027: pay_us_geo_update pgu,
2028: pay_us_city_names pusc,
2029: per_assignments_f pef,
2030: per_people_f ppf
2031: where pgu.process_type = 'NEW_CITY_RECORDS'
2032: and pef.assignment_id = pgu.assignment_id
2033: and ppf.person_id = pef.person_id
2034: and pusc.city_code = substr(new_juri_code,8,4)
2230: from pay_patch_status pps,
2231: pay_us_geo_update pgu,
2232: pay_us_city_names pusc,
2233: per_assignments_f pef,
2234: per_people_f ppf
2235: where pgu.process_type = 'NEW_VERTEX_RECORDS'
2236: and pef.assignment_id = pgu.assignment_id
2237: and ppf.person_id = pef.person_id
2238: and pusc.city_code = substr(new_juri_code,8,4)
2601: substr(puc2.county_name,1,20)
2602: FROM pay_us_modified_geocodes pmod,
2603: pay_us_emp_city_tax_rules_f ectr,
2604: per_assignments_f paf,
2605: per_people_f ppf,
2606: pay_us_counties puc1,
2607: pay_us_counties puc2
2608: WHERE ppf.person_id = paf.person_id
2609: AND pmod.state_code = ectr.state_code