DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_STATES

Line 2790: from pay_us_states pus,

2786: cursor c_get_emp_res_jd(cp_state_abbrev in varchar2
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