Preformance Issue in PL/SQL base Conncurent Profram.

Dear All,

I've a concurrent program base on PL/SQL stored procedure whose performance is very poor it takes too much time to populate the custom created table. The motive is to read records from gl_je_headers , gl_je_lines and gl_code_combinations and than populate the custom table with these record as per user selected as_on_date and account code range. This data is know as trial balance report data which accumulate the entered_dr , entered_cr and accounted_dr , accounted_cr on base of ledger_id, chart_of_accounts_id, currency_code and the entire code_combinations. If any of you have some idea how to reduce the time of the concurrent program.