[Home] [Help]
2988:
2989: SELECT pugp.new_juri_code,pugp.description
2990: FROM pay_us_geo_update pugp,
2991: pay_patch_status pps
2992: WHERE pugp.table_name in ('PER_ADDRESSES','HR_LOCATIONS_ALL')
2993: AND pugp.process_type = 'CN'
2994: AND pugp.id = pps.id
2995: AND pps.patch_name = cp_geocode_patch_name
2996: ORDER BY pugp.description;
3792: substr(addr.town_or_city,1,30),
3793: substr(addr.region_1 ,1,20),
3794: substr(addr.region_2 ,1,5),
3795: substr(addr.postal_code ,1,10)
3796: from per_addresses addr,
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
4107: substr(pgu.description,1,instr(pgu.description,':')-1)
4108: from pay_patch_status pps,
4109: pay_us_geo_update pgu,
4110: per_people_f ppf,
4111: per_addresses pa,
4112: pay_us_modified_geocodes pumg1,
4113: pay_us_modified_geocodes pumg2
4114: where pgu.process_type = 'CY'
4115: and pgu.table_name = 'PER_ADDRESSES'
4111: per_addresses pa,
4112: pay_us_modified_geocodes pumg1,
4113: pay_us_modified_geocodes pumg2
4114: where pgu.process_type = 'CY'
4115: and pgu.table_name = 'PER_ADDRESSES'
4116: and ppf.person_id = pgu.person_id
4117: and pa.person_id = ppf.person_id
4118: and decode(substr(pgu.description,1,instr(pgu.description,':')-1),'Taxation Address',pa.add_information18,pa.town_or_city) =
4119: decode(cp_process_mode,'DEBUG',pumg1.city_name,pumg2.city_name)