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: /* Bug#8606659 */

Line 360: hr_locations hl,

356: SELECT count(1)
357: INTO l_is_exist
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*/

Line 394: hr_locations hl,

390: /* SELECT count(1)
391: INTO l_is_exist
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