APPS.AMS_CTD_UTIL_PKG SQL Statements

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

Line: 54

 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: 81

  /* SELECT 'Y' -- fix for bug 15876260
  FROM ALL_TAB_COLUMNS
  WHERE TABLE_NAME='IES_SVY_SURVEYS_ALL'
  AND COLUMN_NAME = 'SURVEY_TYPE'
  AND OWNER = p_table_owner; */

Line: 87

  SELECT 'Y'
  FROM user_synonyms syn, dba_tab_columns col
  WHERE syn.synonym_name = 'IES_SVY_SURVEYS_ALL'
         AND col.owner = syn.table_owner
         AND col.table_name = syn.table_name
         --AND col.owner = p_table_owner
         AND col.column_name = 'SURVEY_TYPE';

Line: 97

  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: 187

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: 291

select action_param_id,action_param_code
from ams_clik_thru_act_params_b
where action_id=p_action_id;