hi,
thank you for your example. Help me a lot, but my case is a little bit different.
I need to get the security row level base on the login user so I am using a dinamic view with the following code

SELECT rowsecclass
, oprid
FROM (
SELECT rowsecclass
, oprid
FROM SYSADM.psoprdefn )
WHERE %oprclause

With the RowsecClass I need to get the groups and display them in the LookPrompt so I am using a second dynamic view

SELECT group_id
FROM PS_TL_GRP_SECURITY
WHERE rowsecclass in (
SELECT rowsecclass
FROM p_row_sec_vw) <-- CALLING FIRST DINAMIC VIEW