APPS.CSM_HA_SERVICE_PUB SQL Statements

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

Line: 20

 SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,
              'HA_RECORD',ENABLED_ON_RECORD,
              'HA_APPLY',ENABLED_ON_APPLY)
 FROM CSM_HA_ACTIVE_WF_COMPONENTS
 WHERE WF_ITEM_TYPE=p_item_type;

Line: 40

 SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,
              'HA_RECORD',ENABLED_ON_RECORD,
              'HA_APPLY',ENABLED_ON_APPLY)
 FROM CSM_HA_ACTIVE_WF_COMPONENTS
 WHERE WF_EVENT_NAME=p_event_name
 AND  WF_EVENT_SUBSCRIPTION_GUID IS NULL;

Line: 61

 SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,
              'HA_RECORD',ENABLED_ON_RECORD,
              'HA_APPLY',ENABLED_ON_APPLY)
 FROM CSM_HA_ACTIVE_WF_COMPONENTS
 WHERE  WF_EVENT_NAME IS NOT NULL
 AND WF_EVENT_SUBSCRIPTION_GUID =p_sub_guid;