2400: *****************************************************/
2401: BEGIN
2402: SELECT 'Y'
2403: INTO l_exist_res_list 2404: FROM DUAL 2405: WHERE EXISTS
2406: (SELECT 'Y' from pa_resource_list_members
2407: WHERE resource_list_id = P_res_list_id
2408: UNION