DBA Data[Home] [Help]

APPS.PAY_GET_TAX_EXISTS_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 306: hr_soft_coding_keyflex hscf,

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

Line 361: hr_soft_coding_keyflex hscf,

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*/
365: paf.effective_start_date AND paf.effective_end_date

Line 395: hr_soft_coding_keyflex hscf,

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
399: paf.effective_start_date AND paf.effective_end_date