DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_CITY_NAMES

Line 3364: pay_us_city_names pcn

3360: ,cp_city_name in varchar2) is
3361: select pcn.state_code, pcn.county_code, pcn.city_code
3362: from pay_us_states pus,
3363: pay_us_counties puc,
3364: pay_us_city_names pcn
3365: where pus.state_abbrev = cp_state_abbrev
3366: and puc.state_code = pus.state_code
3367: and puc.county_name = cp_county_name
3368: and pcn.state_code = puc.state_code