APPS.CSM_HA_AUDIT_PKG SQL Statements

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

Line: 51

 SELECT SESSION_ID FROM CSM_HA_SESSION_INFO
 WHERE p_ha_payload_id BETWEEN HA_PAYLOAD_START AND HA_PAYLOAD_END;

Line: 56

 SELECT OBJECT_NAME,PK_VALUE,DML_TYPE,MOBILE_DATA
 FROM CSM_HA_PAYLOAD_DATA
 WHERE HA_PAYLOAD_ID=p_ha_payload_id;

Line: 68

 select CSM_HA_AUDIT_S.nextval INTO l_audit_id from dual;

Line: 103

 INSERT INTO CSM_HA_AUDIT(HA_AUDIT_ID,SESSION_ID,HA_PAYLOAD_ID, AUDIT_TYPE, AUDIT_TIMESTAMP,OLD_PAYLOAD,
 CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
 VALUES(l_audit_id,l_session_id,p_ha_payload_id,p_audit_type,systimestamp,DECODE(p_audit_type,'APPLY',xmltype(l_xml_payload)),sysdate,1,sysdate,1,1);