This is done
ADDITIONAL_CREDIT_LIMITS
WHEN OTHERS THEN NULL; -- please change this. WHEN OTHERS should NEVER be NULL. Either remove it or raise an error.
PLEASE PROVIDE CREDIT LIMIT EFFECTIVE FROM DATE TO DATE.