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 356: pay_us_states pus,

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

Line 390: pay_us_states pus,

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

Line 753: FROM pay_us_states pus

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

Line 968: pay_us_states pus

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

Line 2220: FROM pay_us_states pus

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