[Home] [Help]
694: pef.assignment_id ,
695: substr(pef.assignment_number,1,17) ,
696: substr(pgu.description,1,65)
697: from per_people_f ppf,
698: per_assignments_f pef,
699: pay_us_geo_update pgu,
700: pay_patch_status pps,
701: pay_us_emp_city_tax_rules_f pctrf
702: where pef.assignment_id = pgu.assignment_id
906: select distinct substr(ppf.full_name,1,40) ,
907: pef.assignment_id ,
908: substr(pef.assignment_number,1,17)
909: from per_people_f ppf,
910: per_assignments_f pef,
911: pay_us_geo_update pgu,
912: pay_patch_status pps
913: where pgu.process_type = 'PERCENTAGE_OVER_100'
914: and pef.assignment_id = pgu.assignment_id
1091: select distinct substr(ppf.full_name,1,40) ,
1092: pef.assignment_id ,
1093: substr(pef.assignment_number,1,17)
1094: from per_people_f ppf,
1095: per_assignments_f pef,
1096: pay_us_geo_update pgu,
1097: pay_patch_status pps
1098: where pgu.process_type = 'MISSING_COUNTY_RECORDS'
1099: and pef.assignment_id = pgu.assignment_id
1278: from pay_us_modified_geocodes pmod,
1279: pay_us_city_names pusc ,
1280: pay_patch_status pps,
1281: per_people_f ppf,
1282: per_assignments_f pef,
1283: pay_us_geo_update pgu
1284: where pgu.process_type = 'PU'
1285: and pef.assignment_id = pgu.assignment_id
1286: and ppf.person_id = pef.person_id
1512: old_juri_code "Old JD",
1513: new_juri_code "New JD",
1514: substr(table_name,1,20)
1515: from per_people_f ppf,
1516: per_assignments_f pef,
1517: pay_us_geo_update pgu,
1518: pay_us_city_names pusc,
1519: pay_patch_status pps
1520: where pgu.process_type = 'UP'
1729: substr(pust.state_abbrev,1,2),
1730: old_juri_code ,
1731: new_juri_code
1732: from per_people_f ppf,
1733: per_assignments_f pef,
1734: pay_us_geo_update pgu,
1735: pay_us_city_names pusc,
1736: pay_patch_status pps ,
1737: pay_us_states pust,
2002: SUBSTR(pucn.city_name,1,30)
2003: FROM pay_us_modified_geocodes pmod,
2004: pay_us_city_names pucn,
2005: pay_us_emp_city_tax_rules_f ectr,
2006: per_assignments_f paf,
2007: per_people_f ppf
2008: WHERE pmod.process_type = 'P'
2009: AND pmod.state_code = pucn.state_code
2010: AND pmod.county_code = pucn.county_code
2026: SUBSTR(pmod2.city_name,1,30),
2027: SUBSTR(pmod.city_name,1,30)
2028: FROM pay_us_modified_geocodes pmod,
2029: pay_us_emp_city_tax_rules_f ectr,
2030: per_assignments_f paf,
2031: per_people_f ppf,
2032: pay_us_modified_geocodes pmod2
2033: WHERE pmod.process_type = 'S'
2034: and pmod2.process_type in ('UP','PU','P')
2387: pgu.new_juri_code
2388: from pay_patch_status pps,
2389: pay_us_geo_update pgu,
2390: pay_us_city_names pusc,
2391: per_assignments_f pef,
2392: per_people_f ppf
2393: where pgu.process_type = 'NEW_CITY_RECORDS'
2394: and pef.assignment_id = pgu.assignment_id
2395: and ppf.person_id = pef.person_id
2591: pgu.new_juri_code
2592: from pay_patch_status pps,
2593: pay_us_geo_update pgu,
2594: pay_us_city_names pusc,
2595: per_assignments_f pef,
2596: per_people_f ppf
2597: where pgu.process_type = 'NEW_VERTEX_RECORDS'
2598: and pef.assignment_id = pgu.assignment_id
2599: and ppf.person_id = pef.person_id
2962: pmod.state_code||'-'||pmod.new_county_code||'-'||pmod.new_city_code "New JD",
2963: substr(puc2.county_name,1,20)
2964: FROM pay_us_modified_geocodes pmod,
2965: pay_us_emp_city_tax_rules_f ectr,
2966: per_assignments_f paf,
2967: per_people_f ppf,
2968: pay_us_counties puc1,
2969: pay_us_counties puc2
2970: WHERE ppf.person_id = paf.person_id
3515: hla.postal_code "Zipcode"
3516: from hr_locations_all hla
3517: where hla.location_id in
3518: (select distinct location_id
3519: from per_assignments_f paf,
3520: pay_us_emp_city_tax_rules_f pctr
3521: where ( ( pctr.STATE_CODE = '26'
3522: and pctr.county_code = '510'
3523: and pctr.city_code = '1270')
3797: per_all_people_f ppf
3798: where addr.person_id = ppf.person_id
3799: and ppf.person_id in
3800: (select distinct person_id
3801: from per_assignments_f paf,
3802: pay_us_emp_city_tax_rules_f pctr
3803: where ( ( pctr.STATE_CODE = '26'
3804: and pctr.county_code = '510'
3805: and pctr.city_code = '1270')