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: /* Bug#8606659 */
310: -- AND l_date_earned BETWEEN /*6519715*/
311: AND TO_DATE(p_date_earned, 'dd-mm-yyyy') BETWEEN

Line 362: per_assignments_f paf

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
364: AND l_date_earned BETWEEN /*6519715*/
365: paf.effective_start_date AND paf.effective_end_date
366: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 396: per_assignments_f paf

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
398: AND l_date_earned BETWEEN /*6519715
399: paf.effective_start_date AND paf.effective_end_date
400: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id