DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_STATES

Line 3362: from pay_us_states pus,

3358: cursor c_get_emp_res_jd(cp_state_abbrev in varchar2
3359: ,cp_county_name in varchar2
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