DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 51: per_all_assignments_f paf,

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
55: and mg.state_code = tr.state_code

Line 64: from per_all_assignments_f paf,

60:
61: cursor c_geo_check_ca_assignments (p_patch_name in varchar)
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