APPS.CS_SR_SECURITY_UTIL SQL Statements

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

Line: 71

      p_function             => 'CS_SR_TYPES_SELECT_SEC',
      p_object_name          => 'CS_SR_TYPE',
      p_grant_instance_type  => 'SET',
      p_user_name            => 'GLOBAL',
      x_predicate            => lx_predicate,
      x_return_status        => lx_return_status );

Line: 209

      object_name       => 'CS_SR_TYPES_SELECT_SEC',
      policy_name       => 'CS_SR_SEC_SRTYPE_ACCESS',
      enable            => TRUE );

Line: 251

      object_name       => 'CS_SR_TYPES_SELECT_SEC',
      policy_name       => 'CS_SR_SEC_SRTYPE_ACCESS',
      enable            => FALSE );

Line: 288

   select task_id
   from   jtf_task_assignments
   where  task_assignment_id = c_task_assignment_id;

Line: 297

   select source_object_id, source_object_type_code
   from   jtf_tasks_b
   where  task_id = c_task_id;

Line: 307

   select incident_type_id
   from   cs_incidents_all_b
   where  incident_id = c_incident_id;

Line: 330

   select 1
   from   cs_jtf_rs_resource_extns_sec
   where  resource_id = c_resource_id;

Line: 351

   if ( l_event_name = 'oracle.apps.jtf.cac.task.updateTaskAssignment' ) then
      l_resource_id          := p_event.GetValueForParameter('NEW_RESOURCE_ID');

Line: 456

   select owner_id,         owner_type_code ,
	  source_object_id, source_object_type_code
   from   jtf_tasks_b
   where  task_id = c_task_id;

Line: 469

   select incident_type_id
   from   cs_incidents_all_b
   where  incident_id = c_incident_id;

Line: 492

   select 1
   from   cs_jtf_rs_resource_extns_sec
   where  resource_id = c_resource_id;

Line: 622

                  object_name   => 'CS_SR_TYPES_SELECT_SEC',
                  policy_name       => 'CS_SR_SEC_SRTYPE_ACCESS');

Line: 646

                  statement_types => 'SELECT',
                  static_policy   => FALSE,
                  long_predicate  => TRUE );

Line: 653

                  object_name     => 'CS_SR_TYPES_SELECT_SEC',
                  policy_name     => 'CS_SR_SEC_SRTYPE_ACCESS',
                  function_schema => 'APPS',
                  policy_function => 'FND_GENERIC_POLICY.GET_PREDICATE',
                  statement_types => 'SELECT',
                  static_policy   => FALSE,
                  long_predicate  => TRUE );

Line: 668

                  statement_types => 'SELECT',
                  static_policy   => FALSE,
                  long_predicate  => TRUE );

Line: 679

                  statement_types => 'SELECT',
                  static_policy   => FALSE,
                  long_predicate  => TRUE );