DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_COUNTIES

Line 2791: pay_us_counties puc,

2787: ,cp_county_name in varchar2
2788: ,cp_city_name in varchar2) is
2789: select pcn.state_code, pcn.county_code, pcn.city_code
2790: from pay_us_states pus,
2791: pay_us_counties puc,
2792: pay_us_city_names pcn
2793: where pus.state_abbrev = cp_state_abbrev
2794: and puc.state_code = pus.state_code
2795: and puc.county_name = cp_county_name