Payment Process Request Program

 Hi,
We are facing issue with "Payment Process Request Program" taking lot of time to complete almost 3-4 hrs. Usually, it complete in a minute or two.

Looking at the session browser info found the current statement being run goes in full table scan on AP_SYSTEM_PARAMETERS_ALL

Please help to find the issue.

Thanks,

Alhad.

SELECT :p_checkrun_name checkrun_name,

           :p_checkrun_id checkrun_id,

           ps.invoice_id invoice_id,

           ps.payment_num payment_num,

           SYSDATE last_update_date,

           FND_GLOBAL.USER_ID last_updated_by,

           SYSDATE creation_date,

           FND_GLOBAL.USER_ID created_by,

           NULL last_update_login,