APPS.PAY_CTY_BUS dependencies on PAY_US_STATES

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

133: --
134: --
135: -- Description:
136: -- - Determines if the current state code has:
137: -- 1. an entry in the pay_us_states table.
138: --
139: -- Pre_conditions:
140: --
141: -- In Arguments:

Line 167: from pay_us_states

163: --
164: --
165: cursor csr_valid_state_code is
166: select state_code
167: from pay_us_states
168: where state_code = p_state_code;
169: --
170: begin
171: hr_utility.set_location('Entering: '|| l_proc, 5);

Line 1154: from pay_us_states pus,

1150: where paf.assignment_id = p_assignment_id
1151: and hrl.location_id = paf.location_id
1152: and paf.effective_end_date > p_csr_tmp_date
1153: and exists (select null
1154: from pay_us_states pus,
1155: pay_us_counties puc,
1156: pay_us_city_names pucn
1157: where pus.state_abbrev = hrl.region_2
1158: and pus.state_code = p_state_code

Line 1182: from pay_us_states pus,

1178: and pa.person_id = paf.person_id
1179: and pa.primary_flag = 'Y'
1180: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date
1181: and exists (select null
1182: from pay_us_states pus,
1183: pay_us_counties puco,
1184: pay_us_city_names puci
1185: where pus.state_abbrev = pa.region_2
1186: and pus.state_code = p_state_code