[Home] [Help]
71: cursor c_geo_check_ca_assignments (p_patch_name in varchar)
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