PAY: Balance Feeds API not working

Hi,

I wanted to use pay_balance_feeds_api.create_balance_feed procedure to insert the elements on a balance I created. First, I created a table and inserted all the element names that will be used for the balance. Then I created this PL/SQL block below:

DECLARE

CURSOR a_cur is

SELECT INPUT_VALUE_ID, ELEMENT_TYPE_ID
FROM PAY_INPUT_VALUES_F
WHERE NAME = 'Pay Value'
AND ELEMENT_TYPE_ID IN
(SELECT petf.element_type_id
 FROM pay_element_types_f petf, xxc_balance_feed_tbl xbft
 where petf.element_name = xbft.element_name);

w_balance_feed_id NUMBER;