APPS.IEC_RLCTRL_PVT SQL Statements

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

Line: 22

      SELECT LIST_ENTRY_ID
      BULK COLLECT INTO L_LIST_ENTRY_IDS
      FROM AMS_LIST_ENTRIES
      WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y' AND DO_NOT_USE_REASON = P_DNU_REASON_CODE;

Line: 29

      SELECT LIST_ENTRY_ID
      BULK COLLECT INTO L_LIST_ENTRY_IDS
      FROM AMS_LIST_ENTRIES
      WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y';

Line: 39

         UPDATE AMS_LIST_ENTRIES
         SET DO_NOT_USE_FLAG = 'N'
         WHERE LIST_ENTRY_ID = L_LIST_ENTRY_IDS(I);

Line: 44

         UPDATE IEC_G_RETURN_ENTRIES
         SET DO_NOT_USE_FLAG = 'N'
         WHERE LIST_ENTRY_ID = L_LIST_ENTRY_IDS(I);