[Home] [Help]
640: l_group_id NUMBER,
641: l_resource_id NUMBER
642: ) IS
643: SELECT 'Y'
644: FROM jtf_rs_group_members mem
645: WHERE mem.group_id = l_group_id
646: AND mem.resource_id = l_resource_id
647: AND nvl(mem.delete_flag , 'N') <> 'Y';
648: