Tune the Procedure

 Hi,

I have written one procedure.It's taking more than 6 hours for execution. can you please correct the code?

[code]

CREATE OR REPLACE PROCEDURE TEMPO.pr_surprise_delight_lotery
AS

   v_promo_code   game_code.code%TYPE;
   v_date         DATE;

   CURSOR cur_sel_msisdn (v_date DATE)
   IS
      SELECT DISTINCT ref_v.msisdn msisdn, ref_v.recharge_type recharge_type,
                      ref_v.REFERENCE REFERENCE, icat.langcode lang_code
                 FROM tempo.refills_view ref_v, inf_ccard_aicle_tempo icat
                WHERE ref_v.msisdn = icat.cardnbr
                  AND ref_v.currency EXISTS (
                               SELECT prm_id_d
                                 FROM tempo.prm
                                WHERE prm_id_h = 'CURRENCY'