APPS.BIV_DBI_TMPL_SEC SQL Statements

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

Line: 20

and exists ( select 1
             from cs_sr_type_mapping m
             where m.incident_type_id = fact.incident_type_id
             and m.responsibility_id = fnd_global.resp_id
             and trunc(sysdate) between trunc(nvl(m.start_date, sysdate))
                                    and trunc(nvl(m.end_date,sysdate))
           )';

Line: 36

   ( select 1
     from cs_incident_types_vl_sec m
     where incident_subtype = ''INC''
     and m.incident_type_id = fact.incident_type_id
   )';