CREATE VIEW MY_VIEW
AS
SELECT * FROM TABLE1
UNION ALL
SELECT * FROM TABLE2;

CREATE PROCEDURE MY_PROC(IN PARAM XML)
RESULT SETS 1
PL: BEGIN
DECLARE query VARCHAR(31000);
DECLARE c1 cursor with return for s1;
SET query= 'SELECT * FROM TABLE1
WHERE ID IN (select t.id_payment from 
             xmltable(''$c/begin/row'' passing CAST(? as xml) as "c"
             columns id_payment BIGINT path ''id_payment'') as t)';
PREPARE s1 FROM query;
OPEN c1 USING PARAM;
END PL

CREATE PROCEDURE MY_PROC(IN PARAM XML)
RESULT SETS 1
PL: BEGIN
DECLARE query VARCHAR(31000);
DECLARE c1 cursor with return for s1;
SET query= 'SELECT * FROM MY_VIEW
WHERE ID IN (select t.id_payment from 
             xmltable(''$c/begin/row'' passing CAST(? as xml) as "c"
             columns id_payment BIGINT path ''id_payment'') as t)';
PREPARE s1 FROM query;
OPEN c1 USING PARAM;
END PL

CREATE PROCEDURE MY_PROC(IN PARAM XML)
RESULT SETS 1
PL: BEGIN
DECLARE query VARCHAR(31000);
DECLARE c1 cursor with return for s1;
SET query= 'select * from MY_VIEW
where xmlexists(''$c/begin/row[id_payment=$p]'' passing CAST(? as xml) as "c",ID_PAYMENT as "p")';
PREPARE s1 FROM query;
OPEN c1 USING PARAM;
END PL