984: CURSOR get_asg_details(p_asg_id IN NUMBER) IS
985: SELECT pp.payroll_id, asg.person_id, pp.consolidation_set_id, flex.segment1 tax_dist
986: FROM pay_all_payrolls_f pp,
987: per_all_assignments_f asg,
988: hr_soft_coding_keyflex flex
989: WHERE asg.assignment_id = p_asg_id
990: AND asg.payroll_id = pp.payroll_id
991: AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
992: AND pp.soft_coding_keyflex_id = flex.soft_coding_keyflex_id