343: SELECT
344: NVL(hsck.segment18,'N')
345: FROM
346: per_all_assignments_f paaf
347: ,hr_soft_coding_keyflex hsck
348: WHERE
349: paaf.assignment_id = p_assignment_id
350: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
351: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;
349: paaf.assignment_id = p_assignment_id
350: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
351: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;
352:
353: l_section28_reg hr_soft_coding_keyflex.segment18%TYPE ;
354:
355: BEGIN
356: OPEN csr_section28;
357: FETCH csr_section28 INTO l_section28_reg;