function get_filename (p_path IN VARCHAR2) return varchar2 is
    v_file VARCHAR2(1000);

    BEGIN

        IF INSTR(p_path,'\') > 0 THEN
          v_file := SUBSTR(p_path,(INSTR(p_path,'\',-1,1)+1),length(p_path));

        -- If no slashes were found, return the original string
        ELSE
          v_file := p_path;

        END IF;

        RETURN v_file;

    END;