APPS.AMS_EVENT_OBJECTS_COPY_PVT SQL Statements

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

Line: 39

        SELECT   event_header_name
          FROM     ams_event_headers_vl
          WHERE  parent_event_header_id = p_agenda_id;

Line: 63

        SELECT   event_offer_name
          FROM     ams_event_offers_vl
          WHERE  parent_event_offer_id = p_offer_id;

Line: 110

      SELECT event_header_id
      FROM ams_event_offers_vl
      WHERE  event_offer_id=l_event_offer_id;

Line: 118

      SELECT ACTIVE_FROM_DATE, ACTIVE_TO_DATE
      FROM ams_event_headers_vl
      WHERE  EVENT_HEADER_ID = l_new_event_header_id;

Line: 201

             UPDATE ams_event_offers_all_b
             SET event_header_id = p_new_act_id
             WHERE event_offer_id = l_new_object_id;

Line: 266

         SELECT
         DLT.deliverable_name ,
         DLV.custom_setup_id,
         CAT.category_id,
         OBJ.master_object_id,
         OBJ.object_association_id,
         OBJ.using_object_id,
         CAT.category_name ,
         OBJ.object_version_number,
         OBJ.quantity_needed,
         OBJ.fulfill_on_type_code,
         OBJ.master_object_type,
         OBJ.quantity_needed_by_date,
         OBJ.USING_OBJECT_TYPE,
          OBJ.primary_flag,
          OBJ.USAGE_TYPE
        FROM
         AMS_OBJECT_ASSOCIATIONS OBJ,
	 AMS_DELIVERABLES_ALL_B DLV,
	AMS_DELIVERABLES_ALL_TL DLT,
	 AMS_CATEGORIES_TL CAT
	WHERE
	 OBJ.master_object_id = p_src_act_id AND
	 OBJ.USING_OBJECT_TYPE = 'DELV' AND
	 OBJ.USING_OBJECT_ID = DLV.DELIVERABLE_ID AND
	 OBJ.USING_OBJECT_ID = DLT.DELIVERABLE_ID AND
	 DLT.LANGUAGE = USERENV('LANG') AND
	 DLV.CATEGORY_TYPE_ID = CAT.CATEGORY_ID AND
	 CAT.LANGUAGE = USERENV('LANG') AND
	 OBJ.master_object_type =p_src_act_type;

Line: 419

      SELECT
         event_header_id
	,last_update_date
	,last_updated_by
	,creation_date
	,created_by
	,last_update_login
	,object_version_number
	,event_level
	,application_id
	,event_type_code
	,active_flag
	,private_flag
	,user_status_id
	,system_status_code
	,last_status_date
	,stream_type_code
	,source_code
	,event_standalone_flag
	,day_of_event
	,agenda_start_time
	,agenda_end_time
	,reg_required_flag
	,reg_charge_flag
	,reg_invited_only_flag
	,partner_flag
	,overflow_flag
	,parent_event_header_id
	,duration
	,duration_uom_code
	,active_from_date
	,active_to_date
	,reg_maximum_capacity
	,reg_minimum_capacity
	,main_language_code
	,cert_credit_type_code
	,certification_credits
	,inventory_item_id
	,organization_id
	,org_id
	,forecasted_revenue
	,actual_revenue
	,forecasted_cost
	,actual_cost
	,coordinator_id
	,fund_source_type_code
	,fund_source_id
	,fund_amount_tc
	,fund_amount_fc
        ,currency_code_tc
        ,currency_code_fc
	,owner_user_id
	,url
	,email
	,phone
	,priority_type_code
	,cancellation_reason_code
	,inbound_script_name
	,attribute_category
	,attribute1
	,attribute2
	,attribute3
	,attribute4
	,attribute5
	,attribute6
	,attribute7
	,attribute8
	,attribute9
	,attribute10
	,attribute11
	,attribute12
	,attribute13
	,attribute14
	,attribute15
   	,event_header_name
   	,event_mktg_message
   	,description
        ,setup_type_id
        ,country_code
        ,business_unit_id
	,event_calendar
	,start_period_name
	,end_period_name
	,global_flag
	,task_id
	,program_id
	,CREATE_ATTENDANT_LEAD_FLAG
	,CREATE_REGISTRANT_LEAD_FLAG
          ,EVENT_PURPOSE_CODE
 FROM ams_event_headers_vl
 WHERE parent_event_header_id =  p_src_act_id
      AND event_level='SUB';