[Home] [Help]
22: cursor c_geocode_patch_name is
23: select patch_name,
24: Substr( patch_name,
25: greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4)
26: from pay_us_modified_geocodes
27: where patch_name like '%GEO%'
28: and Substr( patch_name,
29: greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4) >= '2001'
30: group by patch_name
54:
55: cursor c_geo_check_us_assignments (p_patch_name in varchar)
56: is
57: select count (tr.assignment_id)
58: from pay_us_modified_geocodes mg,
59: pay_us_emp_city_tax_rules_f tr,
60: per_all_assignments_f paf,
61: pay_us_states pus
62: where mg.patch_name = p_patch_name
72: is
73: select count(pac.assignment_id)
74: from per_all_assignments_f paf,
75: pay_action_contexts pac,
76: pay_us_modified_geocodes pmod
77: where pmod.state_code = '70'
78: and pmod.county_code = pac.context_value
79: and pac.context_id in (select context_id
80: from ff_contexts
85: cursor c_geo_county_change_adds (p_patch_name in varchar)
86: is
87: select count(person_id)
88: from per_addresses pa,
89: pay_us_modified_geocodes pmod,
90: pay_us_states pus
91: where pmod.state_code = pus.state_code
92: and (( pa.country = decode(pus.state_code,70,'CA','US')
93: and pus.state_abbrev = pa.region_2
101: cursor c_geo_county_change_locs (p_patch_name in varchar)
102: is
103: select count(location_id)
104: from hr_locations_all hl,
105: pay_us_modified_geocodes pmod,
106: pay_us_states pus
107: where pmod.state_code = pus.state_code
108: and (( hl.country = decode(pus.state_code,70,'CA','US')
109: and pus.state_abbrev = hl.region_2
116:
117: cursor c_geo_city_changes (p_patch_name in varchar)
118: is
119: select count(*)
120: from pay_us_modified_geocodes pmod
121: where pmod.patch_name = p_patch_name
122: and pmod.process_type = 'CY';
123:
124: list_index number:=1;