APPS.CSD_WF_PROCESS_PVT SQL Statements

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

Line: 32

select sr.cont_email,
       sr.incident_number,
       ro.repair_number,
       ro.serial_number,
       sr.item,
       decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
from csd_incidents_v sr,
     csd_repairs ro
where ro.incident_id  = sr.incident_id
and ro.repair_line_id = p_repair_line_id;

Line: 45

Select wr.name
from wf_roles wr,
     cs_incidents_v sr,
     csd_repairs    ro
where ro.repair_line_id = p_repair_line_id
and ro.incident_id = sr.incident_id
and wr.orig_system_id = sr.contact_party_id
and wr.orig_system = 'HZ_PARTY'
and nvl(wr.expiration_date,sysdate) >= sysdate
and wr.status = 'ACTIVE';