DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 50: pay_us_emp_city_tax_rules_f tr,

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
54: and mg.state_code = pus.state_code