Execute the select below to find out routines from a specific package.

select distinct a.routinename, b.bname from syscat.routines a, 
syscat.routinedep b, syscat.packages c where c.valid = 'N' and 
b.routinename = a.specificname and b.bname = c.pkgname and c.pkgname in 
('<PACKAGENAME>')

Exemplo:

select distinct a.routinename, b.bname as packagefrom syscat.routines a, syscat.routinedep b, syscat.packages c where c.valid = 'N' 
and b.routinename = a.specificname and b.bname = c.pkgname  and c.pkgname in ('P9472108')

Output:

ROUTINENAME PACKAGE
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
FN_VALIDA_SEXO P9472108