80: --
81: SELECT scl.segment1
82: INTO l_tax_unit_id
83: FROM hr_soft_coding_keyflex scl, 84: per_assignments_f paf 85: where scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
86: and paf.assignment_id = p_assignment_id
87: and p_session_date between paf.effective_start_date AND paf.effective_end_date;
88: --