APPS.EAM_PM_LAST_SERVICE_PUB SQL Statements

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

Line: 50

      select 'X' from dual where exists
        (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_meter_id
         union
         select COUNTER_ID from CSI_COUNTER_TEMPLATE_B where counter_id = p_meter_id) ;

Line: 55

   /* SELECT 'X'
      from eam_counters_v where meter_id = p_meter_id;*/

Line: 60

 SELECT 'X'
 from mtl_eam_asset_activities where activity_association_id = p_activity_association_id;

Line: 65

 SELECT 'X' from mtl_eam_asset_activities meaa, CSI_COUNTER_ASSOCIATIONS eam,
  CSI_COUNTERS_B em where meaa.activity_association_id
  = p_activity_association_id
  and meaa.maintenance_object_id = eam.SOURCE_OBJECT_ID and eam.COUNTER_id =
  em.COUNTER_id and eam.COUNTER_id = p_meter_id and em.used_in_scheduling = 'Y' ;

Line: 71

   /* SELECT 'X'
   from mtl_eam_asset_activities meaa, eam_asset_meters_v eam, eam_counters_v em
   where meaa.activity_association_id = p_activity_association_id
    and meaa.maintenance_object_id = eam.maintenance_object_id
    and eam.meter_id = em.meter_id
    and eam.meter_id = p_meter_id
     and em.used_in_scheduling = 'Y';*/

Line: 150

CURSOR c_check_update(p_meter_id  number, p_actv_assoc_id number)
IS
 SELECT 'X'
 from EAM_PM_LAST_SERVICE where meter_id = p_meter_id and activity_association_id = p_actv_assoc_id;

Line: 191

	        open c_check_update(p_pm_last_service_tbl(i).meter_id,p_actv_assoc_id);

Line: 192

	        fetch c_check_update into l_dummy;

Line: 193

	        if c_check_update%NOTFOUND
	        THEN
			INSERT INTO EAM_PM_LAST_SERVICE
			(
				METER_ID		,
				ACTIVITY_ASSOCIATION_ID ,
				LAST_SERVICE_READING    ,
				PREV_SERVICE_READING    ,
				--WIP_ENTITY_ID           ,

				CREATED_BY           ,
				CREATION_DATE       ,
				LAST_UPDATE_LOGIN  ,
				LAST_UPDATE_DATE  ,
				LAST_UPDATED_BY
			)
			VALUES
			(
				p_pm_last_service_tbl(i).METER_ID		,
				p_actv_assoc_id,
				p_pm_last_service_tbl(i).LAST_SERVICE_READING	,
				p_pm_last_service_tbl(i).PREV_SERVICE_READING	,
				--p_WIP_ENTITY_ID       	,

				fnd_global.user_id,
				sysdate,
				fnd_global.login_id,
				sysdate    ,
				fnd_global.user_id
			);

Line: 225

			UPDATE EAM_PM_LAST_SERVICE
			SET
			   METER_ID	 	 =	p_pm_last_service_tbl(i).METER_ID,
			   ACTIVITY_ASSOCIATION_ID	 =	p_actv_assoc_id,
			   LAST_SERVICE_READING	 =	p_pm_last_service_tbl(i).LAST_SERVICE_READING,
			   PREV_SERVICE_READING	 =	p_pm_last_service_tbl(i).PREV_SERVICE_READING,
			   --WIP_ENTITY_ID       	 =	p_WIP_ENTITY_ID       ,

				LAST_UPDATE_LOGIN	 =	fnd_global.login_id	,
				LAST_UPDATE_DATE	 =	sysdate	,
				LAST_UPDATED_BY		 =	fnd_global.user_id
			WHERE METER_ID = p_pm_last_service_tbl(i).METER_ID AND
			      ACTIVITY_ASSOCIATION_ID = p_actv_assoc_id;

Line: 239

		CLOSE c_check_update;