2415: *****************************************************/
2416: BEGIN
2417: SELECT 'Y'
2418: INTO l_exist_res_list 2419: FROM DUAL 2420: WHERE EXISTS
2421: (SELECT 'Y' from pa_resource_list_members
2422: WHERE resource_list_id = P_res_list_id
2423: UNION