DBA Data[Home] [Help]

APPS.PAY_GET_TAX_EXISTS_PKG dependencies on HR_LOCATIONS

Line 305: hr_locations hl,

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
309: AND l_date_earned BETWEEN /*6519715*/

Line 357: hr_locations hl,

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
361: AND l_date_earned BETWEEN /*6519715*/

Line 391: hr_locations hl,

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
395: AND l_date_earned BETWEEN /*6519715