APPS.BEN_BENHIPAA_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

     update_pcd_sent_dt(p_per_cm_prvdd_id  => per_cm_prvdd_id
               ,p_effective_Date   => p_effective_Date );

Line: 34

PROCEDURE update_pcd_sent_dt(p_per_cm_prvdd_id in number
                             ,p_effective_Date in date ) IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 38

   update ben_per_cm_prvdd_f
     set sent_Dt = p_effective_Date
      where per_cm_prvdd_id = p_per_cm_prvdd_id
        and  sent_dt is null
        and   p_effective_Date between
              effective_Start_date and
              effective_end_Date  ;