i am trying to get the groups i which the user is tagged as member from the sys_user_grmember table. i have a field in the catalog "bank_id" which will be queried against the user.user_name field in the sys_user_grmember table. i need to put an additonal filter where the group type contains vrm. i have written a lookup records function to get the list. how to delete the records based on an if condition. if the count of the look up record is 0, the task will close without action. if the count of the look up record is greater than 0, then delete all the entries fetched as part of the look up record.
please help
