APPS.CS_WF_ACTIVITIES_CUST SQL Statements

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

Line: 124

      SELECT *
        FROM CS_INCIDENTS_WORKFLOW_V
       WHERE incident_id = l_request_id;

Line: 133

      SELECT emp.source_id
      FROM jtf_rs_resource_extns emp,
        cs_incidents_all_b inc
      WHERE inc.incident_id = l_request_id
        AND emp.resource_id = inc.incident_owner_id;

Line: 225

  PROCEDURE Update_Escalation_Hist( itemtype       VARCHAR2,
                                    itemkey        VARCHAR2,
                                    actid          NUMBER,
                                    funmode        VARCHAR2,
                                    result     OUT NOCOPY VARCHAR2 ) IS
    l_owner_name	VARCHAR2(240);

Line: 304

      WF_CORE.Context('CS_WF_ACTIVITIES_CUST', 'Update_Escalation_Hist',
		      itemtype, itemkey, actid, funmode);

Line: 308

  END Update_Escalation_Hist;