Reference no: EM133092

Question

In following case statement replaces the +14, + 7, +3 with values that are pulled from a table known as checkout_periods with material_type and days being relevant columns. Any assistance in this coding is appreciated

ELSE
CASE v_material_type
WHEN 'VHS TAPE' THEN v_due_date := p_checkout_date + 14;
WHEN 'DVD' THEN v_due_date := p_checkout_date + 7;
WHEN 'BLU-RAY' THEN v_due_date := p_checkout_date + 3;
END CASE;