APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_US_STATES

Line 171: pay_us_states pus,

167:
168: CURSOR c_override_state_county IS
169: SELECT puc.state_code || '-' || puc.county_code
170: FROM pay_us_counties puc,
171: pay_us_states pus,
172: per_addresses pa,
173: per_assignments_f paf
174: WHERE paf.assignment_id = p_assign_id
175: AND paf.person_id = pa.person_id

Line 218: pay_us_states pus,

214: SELECT puc.state_code || '-' || puc.county_code,
215: pa.date_from
216: INTO l_rs_county_code, l_res_adr_date_start
217: FROM pay_us_counties puc,
218: pay_us_states pus,
219: per_addresses pa,
220: per_assignments_f paf
221: WHERE paf.assignment_id = p_assign_id
222: AND paf.person_id = pa.person_id

Line 304: pay_us_states pus,

300:
301: CURSOR c_override_location IS
302: SELECT 'Y'
303: FROM pay_us_counties puc,
304: pay_us_states pus,
305: hr_locations hl,
306: hr_soft_coding_keyflex hscf,
307: per_assignments_f paf
308: WHERE paf.assignment_id = p_assign_id

Line 359: pay_us_states pus,

355: hr_utility.trace('rec_multiassgn.assignment_id: '|| to_char(rec_multiassgn.assignment_id));
356: SELECT count(1)
357: INTO l_is_exist
358: FROM pay_us_counties puc,
359: pay_us_states pus,
360: hr_locations hl,
361: hr_soft_coding_keyflex hscf,
362: per_assignments_f paf
363: WHERE paf.assignment_id = rec_multiassgn.assignment_id

Line 393: pay_us_states pus,

389: RETURN (FALSE);
390: /* SELECT count(1)
391: INTO l_is_exist
392: FROM pay_us_counties puc,
393: pay_us_states pus,
394: hr_locations hl,
395: hr_soft_coding_keyflex hscf,
396: per_assignments_f paf
397: WHERE paf.assignment_id = p_assign_id

Line 756: FROM pay_us_states pus

752: */
753:
754: SELECT DISTINCT pus.state_abbrev
755: INTO l_state_abbrev
756: FROM pay_us_states pus
757: WHERE pus.state_code = SUBSTR(p_juri_code, 1, 2);
758:
759: hr_utility.trace('The state abbrev is:' || l_state_abbrev);
760:

Line 971: pay_us_states pus

967:
968: select 'Y'
969: into l_wc_exists
970: from hr_organization_information hoi,
971: pay_us_states pus
972: where organization_id = p_tax_unit_id
973: and hoi.org_information_context = 'State Tax Rules'
974: and hoi.org_information1 = pus.state_abbrev
975: and pus.state_code = substr(p_juri_code,1,2)

Line 2223: FROM pay_us_states pus

2219: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2220:
2221: SELECT DISTINCT pus.state_abbrev
2222: INTO l_state_abbrev
2223: FROM pay_us_states pus
2224: WHERE pus.state_code = SUBSTR(p_juri_code, 1, 2);
2225:
2226: hr_utility.trace('The state abbrev is:' || l_state_abbrev);
2227: