APPS.PAY_CNT_BUS dependencies on PAY_US_STATES

Line 144: -- - 1. an entry in the pay_us_states table.

140: --
141: --
142: -- Description:
143: -- - Determines if the current state code has:
144: -- - 1. an entry in the pay_us_states table.
145: --
146: -- Pre_conditions:
147: --
148: -- In Arguments:

Line 175: from pay_us_states

171: --
172: --
173: cursor csr_valid_state_code is
174: select state_code
175: from pay_us_states
176: where state_code = p_state_code;
177: --
178: begin
179: hr_utility.set_location('Entering: '|| l_proc, 5);

Line 1167: from pay_us_states pus,

1163: where paf.assignment_id = p_assignment_id
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

Line 1190: from pay_us_states pus,

1186: and pa.person_id = paf.person_id
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