APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PAY_US_MODIFIED_GEOCODES

Line 26: from pay_us_modified_geocodes

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

Line 49: from pay_us_modified_geocodes mg,

45:
46: cursor c_geo_check_us_assignments (p_patch_name in varchar)
47: is
48: select count (tr.assignment_id)
49: from pay_us_modified_geocodes mg,
50: pay_us_emp_city_tax_rules_f tr,
51: per_all_assignments_f paf,
52: pay_us_states pus
53: where mg.patch_name = p_patch_name

Line 66: pay_us_modified_geocodes pmod

62: is
63: select count(pac.assignment_id)
64: from per_all_assignments_f paf,
65: pay_action_contexts pac,
66: pay_us_modified_geocodes pmod
67: where pmod.state_code = '70'
68: and pmod.county_code = pac.context_value
69: and pac.context_id in (select context_id
70: from ff_contexts