APPS.PAY_CNT_BUS dependencies on PAY_US_COUNTIES

Line 211: -- - 1. an entry in the pay_us_counties table, where the state_code

207: --
208: --
209: -- Description:
210: -- - Determines if the current county_code has:
211: -- - 1. an entry in the pay_us_counties table, where the state_code
212: -- matches the tax record state_code.
213: --
214: -- Pre_conditions:
215: -- A valid state_code

Line 245: from pay_us_counties

241: --
242: --
243: cursor csr_valid_county_code is
244: select county_code
245: from pay_us_counties
246: where state_code = p_state_code
247: and county_code = p_county_code;
248: --
249: begin

Line 1168: pay_us_counties puc

1164: and hrl.location_id = paf.location_id
1165: and paf.effective_end_date > p_csr_tmp_date
1166: and exists (select null
1167: from pay_us_states pus,
1168: pay_us_counties puc
1169: where pus.state_abbrev = hrl.region_2
1170: and pus.state_code = p_state_code
1171: and puc.state_code = pus.state_code
1172: and puc.county_name = hrl.region_1

Line 1191: pay_us_counties puco

1187: and pa.primary_flag = 'Y'
1188: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date
1189: and exists (select null
1190: from pay_us_states pus,
1191: pay_us_counties puco
1192: where pus.state_abbrev = pa.region_2
1193: and pus.state_code = p_state_code
1194: and puco.state_code = pus.state_code
1195: and puco.county_name = pa.region_1