GRN, thanks for the suggestion to use COUNT as a way to determine the package. Since I need a query for a data conversion I came up with the...

Here is the recursive fuction that does most of work:

-- ==========================================

-- fn_GetPkgRecursive is a function that recuresively calls 

-- itself but ultimately returns package numbers that...

I created 2 functions. One to prepare the for a call to the main recursive function. Here is the first:

-- ==================================

-- fn_GetCustPkg is a...