441:
442: IF get_sls_threshold_max_exp_sls IS NULL THEN --{
443: SELECT MAX(expctd_sls)
444: INTO get_sls_threshold_max_exp_sls
445: FROM ddr_r_excptn_sls_thrshld;
446: END IF;
447:
448: IF v_exp_sls IS NULL THEN --{
449: RETURN;
458: END IF; --}
459:
460: SELECT min_thrshld_actl_sls
461: INTO p_sls_threshold
462: FROM ddr_r_excptn_sls_thrshld
463: WHERE expctd_sls = ROUND(v_exp_sls);
464: EXCEPTION
465: WHEN OTHERS THEN
466: x_return_status := ddr_emd_util.error;