APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_US_COUNTIES

Line 170: FROM pay_us_counties puc,

166: RETURN varchar2 IS
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

Line 217: FROM pay_us_counties puc,

213: hr_utility.trace('5030 Fetching County Code for Res Jurisdiction ');
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

Line 303: FROM pay_us_counties puc,

299: /*Bug#6768746: Changes ends here*/
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

Line 355: FROM pay_us_counties puc,

351: LOOP
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

Line 389: FROM pay_us_counties puc,

385: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));
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