APPS.DPP_TRANSACTION_STATUS_MAP_PKG SQL Statements

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

Line: 16

    SELECT rowid FROM DPP_TRANSACTION_STATUS_MAP
    WHERE FROM_STATUS = C_FROM_STATUS
    AND TO_STATUS = C_TO_STATUS;

Line: 24

   update DPP_TRANSACTION_STATUS_MAP
   set ENABLED_FLAG = P_ENABLED_FLAG,
       LAST_UPDATE_DATE = SYSDATE,
       LAST_UPDATED_BY = l_user_id,
       LAST_UPDATE_LOGIN = l_login_id
    where from_status = P_FROM_STATUS
    and to_status= P_TO_STATUS;

Line: 34

    	Insert into DPP_TRANSACTION_STATUS_MAP
    		(FROM_STATUS,
    		TO_STATUS,
    		ENABLED_FLAG,
    		CREATION_DATE,
    		CREATED_BY,
    		LAST_UPDATE_DATE,
    		LAST_UPDATED_BY,
    		LAST_UPDATE_LOGIN)
    	VALUES (P_FROM_STATUS,
    		P_TO_STATUS,
    		P_ENABLED_FLAG,
    		SYSDATE,
    		l_user_id,
    		SYSDATE,
    		l_user_id,
    		l_login_id);