APPS.AMS_METRICCUSTOM_PVT SQL Statements

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

Line: 46

  SELECT a.arc_act_metric_used_by,
         a.act_metric_used_by_id,
         a.metric_id,
         b.metric_category,
         b.metric_sub_category,
         a.object_version_number,
         a.transaction_currency_code
  FROM ams_act_metrics_all a, ams_metrics_all_b b
  WHERE a.metric_id = b.metric_id
  and activity_metric_id = p_act_met_id;

Line: 72

  SELECT campaign_id
  FROM   ams_campaigns_all_b
  WHERE  parent_campaign_id = p_current_campaign_id ;

Line: 77

  SELECT event_offer_id
  FROM ams_event_offers_all_b
  WHERE event_header_id = p_current_event_id;

Line: 83

  SELECT using_object_type, using_object_id
  FROM  ams_object_associations
  WHERE master_object_type = p_obj_cd
        AND master_object_id = p_obj_id
        AND usage_type= 'CREATED';

Line: 96

  SELECT max(func_actual_value),
         max(func_forecasted_value)
  FROM   ams_act_metrics_all a
  WHERE  arc_act_metric_used_by  = p_arc
  AND    act_metric_used_by_id   = p_id
  AND EXISTS (select 'x' from ams_metrics_all_b b
     where b.metric_id = a.metric_id
  AND    metric_category      = p_category_id
  AND    metric_sub_category  = p_sub_category_id);

Line: 193

  Ams_ActMetric_pvt.Update_ActMetric (
    p_api_version => '1.0',
    p_commit=>FND_API.G_TRUE,
    x_return_status => l_return_status,
    x_msg_count => l_msg_count,
    x_msg_data => l_msg_data,
    p_act_metric_rec => l_metric_rec);