APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on HR_SOFT_CODING_KEYFLEX

Line 492: hr_soft_coding_keyflex flex

488: CURSOR get_asg_details(p_asg_id IN NUMBER) IS
489: SELECT pp.payroll_id, asg.person_id, pp.consolidation_set_id, flex.segment1 tax_dist
490: FROM pay_all_payrolls_f pp,
491: per_all_assignments_f asg,
492: hr_soft_coding_keyflex flex
493: WHERE asg.assignment_id = p_asg_id
494: AND asg.payroll_id = pp.payroll_id
495: AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
496: AND pp.soft_coding_keyflex_id = flex.soft_coding_keyflex_id