my $xp = XML::XPath->new( ioref => $input );
my $mp = $xp->find('/meta-parameter');
for my $n ($mp->get_nodelist) {
    if( $xp->findvalue('@type' => $n) eq "stored-procedure" ) {
        warn "found: " . $xp->findvalue( '@id' => $n );
    }
}