APPS.BIM_EDW_CMPFRCST_F_SIZE SQL Statements

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

Line: 13

   select sum(cnt)
   from (
        select count(*) cnt
	FROM AMS_CAMPAIGNS_ALL_B AMC ,
	 AMS_ACT_METRICS_ALL AAM ,
	 AMS_METRICS_ALL_B AMT ,
	 BIM_EDW_CMPFRCST_INC INC ,
	 EDW_LOCAL_INSTANCE INST
	WHERE AMC.CAMPAIGN_ID = AAM.ACT_METRIC_USED_BY_ID
	 AND AAM.ARC_ACT_METRIC_USED_BY = 'CAMP'
	 AND AAM.METRIC_ID = AMT.METRIC_ID
	 AND AMT.SUMMARY_METRIC_ID IS NULL AND AMT.METRIC_CATEGORY = 901
	 AND AMC.STATUS_CODE NOT IN ( 'NEW',
	 'PLANNING' ) AND AMC.SHOW_CAMPAIGN_FLAG = 'Y'
	 AND AMC.CAMPAIGN_ID = INC.PRIMARY_KEY
	 AND  ( AMC.LAST_UPDATE_DATE > last_date
	 OR  AAM.LAST_UPDATE_DATE > last_date
	 )  and
	AMC.last_update_date between
        p_from_date  and  p_to_date
	UNION ALL
	select count(*) cnt
	FROM AMS_CAMPAIGNS_ALL_B AMC ,
	 AMS_ACT_METRICS_ALL AAM ,
	 AMS_METRICS_ALL_B AMT ,
	 BIM_EDW_CMPFRCST_INC INC ,
	 EDW_LOCAL_INSTANCE INST
	WHERE AMC.CAMPAIGN_ID = AAM.ACT_METRIC_USED_BY_ID
	 AND AAM.ARC_ACT_METRIC_USED_BY = 'CAMP'
	 AND AAM.METRIC_ID = AMT.METRIC_ID AND AMT.SUMMARY_METRIC_ID IS NULL
	 AND AMT.METRIC_CATEGORY = 902 AND AMC.STATUS_CODE NOT IN ( 'NEW',
	 'PLANNING' )
	 AND AMC.SHOW_CAMPAIGN_FLAG = 'Y' AND AMC.CAMPAIGN_ID = INC.PRIMARY_KEY
	 AND (  AMC.LAST_UPDATE_DATE > last_date
	 OR  AAM.LAST_UPDATE_DATE > last_date )
        );

Line: 80

	SELECT
	avg(nvl(vsize( CAMPAIGN_ID), 0)),
	avg(nvl(vsize( CHANNEL_ID), 0)),
	avg(nvl(vsize( TRANSACTION_CURRENCY_CODE), 0)),
	avg(nvl(vsize( ORG_ID), 0))
	FROM AMS_CAMPAIGNS_ALL_B
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 93

	select
	 avg(nvl(vsize(INSTANCE_CODE), 0))
	 from EDW_LOCAL_INSTANCE ;