[Home] [Help]
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
351: and ppf.person_id = pef.person_id
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'
550: and pef.assignment_id = pgu.assignment_id
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'
735: and pef.assignment_id = pgu.assignment_id
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
922: and ppf.person_id = pef.person_id
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
1156: where pgu.process_type = 'UP'
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 ,
1373: pay_us_states pust,
1638: SUBSTR(pucn.city_name,1,20)
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
1662: SUBSTR(pmod.city_name,1,20)
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
2025: pgu.new_juri_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
2229: pgu.new_juri_code
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
2600: pmod.state_code||'-'||pmod.new_county_code||'-'||pmod.new_city_code "New JD",
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
3104: hla.postal_code "Zipcode"
3105: from hr_locations_all hla
3106: where hla.location_id in
3107: (select distinct location_id
3108: from per_assignments_f paf,
3109: pay_us_emp_city_tax_rules_f pctr
3110: where ( ( pctr.STATE_CODE = '26'
3111: and pctr.county_code = '510'
3112: and pctr.city_code = '1270')
3383: per_all_people_f ppf
3384: where addr.person_id = ppf.person_id
3385: and ppf.person_id in
3386: (select distinct person_id
3387: from per_assignments_f paf,
3388: pay_us_emp_city_tax_rules_f pctr
3389: where ( ( pctr.STATE_CODE = '26'
3390: and pctr.county_code = '510'
3391: and pctr.city_code = '1270')