DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 60: per_all_assignments_f paf,

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
63: and mg.state_code = pus.state_code
64: and mg.state_code = tr.state_code

Line 74: from per_all_assignments_f paf,

70:
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