APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PER_ASSIGNMENTS_F

Line 173: per_assignments_f paf

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
176: AND pa.primary_flag = 'Y'
177: AND TO_DATE(l_date_earned, 'DD-MM-YYYY') BETWEEN

Line 220: per_assignments_f paf

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
223: AND pa.primary_flag = 'Y'
224: AND TO_DATE(l_date_earned, 'DD-MM-YYYY') BETWEEN

Line 307: per_assignments_f paf

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
309: AND l_date_earned BETWEEN /*6519715*/
310: paf.effective_start_date AND paf.effective_end_date
311: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 359: per_assignments_f paf

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
361: AND l_date_earned BETWEEN /*6519715*/
362: paf.effective_start_date AND paf.effective_end_date
363: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 393: per_assignments_f paf

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
395: AND l_date_earned BETWEEN /*6519715
396: paf.effective_start_date AND paf.effective_end_date
397: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id