APPS.BEN_BEN_US_COBNL_XMLP_PKG SQL Statements

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

Line: 8

   select   admin_name || ', ' || loc_addr1 ||', ' ||
            loc_Addr2 || decode(loc_addr2, null,'',', ') ||
            loc_Addr3 || decode(loc_addr3, null,'',', ') ||
            loc_city || ', ' || loc_state || ', ' ||
            loc_zip || decode( loc_phone , null,'',', Phone : ')||loc_phone ||'.'
    into  mvar
     from dual ;

Line: 16

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

Line: 30

procedure update_pcd_sent_dt(p_per_cm_prvdd_id in number
                             ,p_effective_date in date ) is

PRAGMA AUTONOMOUS_TRANSACTION;

Line: 36

   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  ;

Line: 65

   select meaning from
   hr_lookups hr
   where hr.lookup_code = cmcd_acty_ref_perd_cd
     and hr.lookup_type = 'BEN_ENRT_INFO_RT_FREQ' ;