APPS.AMS_CTD_UTIL_PKG SQL Statements

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

Line: 52

 SELECT
 DECODE(e.parent_type,'CAMP',s.source_code,e.source_code) event_source_code
 FROM
 AMS_EVENT_OFFERS_ALL_B e,
 ams_campaign_schedules_b s
 WHERE
 e.event_offer_id = s.related_event_id (+)
 AND     s.related_event_from(+) = 'EONE'
 AND   e.EVENT_OFFER_ID = p_event_id;

Line: 79

  SELECT 'Y'
  FROM ALL_TAB_COLUMNS
  WHERE TABLE_NAME='IES_SVY_SURVEYS_ALL'
  AND COLUMN_NAME = 'SURVEY_TYPE'
  AND OWNER = p_table_owner;

Line: 87

  select svy.survey_type
  from ies_svy_surveys_all svy,
       IES_SVY_CYCLES_ALL cyc,
       IES_SVY_DEPLYMENTS_ALL dep
  where dep.survey_deployment_id = p_deployment_id
  and dep.survey_cycle_id = cyc.survey_cycle_id
  and cyc.survey_id = svy.survey_id;

Line: 177

select source_code_id from ams_source_codes
where arc_source_code_for = 'CSCH'
and source_code_for_id = p_schedule_id
and active_flag='Y';

Line: 281

select action_param_id,action_param_code
from ams_clik_thru_act_params_b
where action_id=p_action_id;