APPS.EDW_LOOKUP_M_C SQL Statements

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

Line: 68

 l_rows_inserted        Number := 0;

Line: 91

   Insert Into EDW_LKUP_LOOKUP_CODE_LSTG(
     ALL_FK,
     ALL_FK_KEY,
     ROW_ID,
     DESCRIPTION,
     LOOKUP_CODE_DP,
     NAME,
     END_DATE_ACTIVE,
     INSTANCE,
     LAST_UPDATE_DATE,
     LOOKUP_CODE,
     LOOKUP_CODE_PK,
     LOOKUP_TYPE,
     START_DATE_ACTIVE,
     TABLE_CODE,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     REQUEST_ID,
     OPERATION_CODE,
     ERROR_CODE,
     COLLECTION_STATUS)
   select
     'ALL', 		-- ALL_FK
     NULL,		-- ALL_FK_KEY
     NULL, 		-- ROW_ID
     DESCRIPTION,
     lookup_codes_dp, 	-- DISPLAYED_NAME,
     NAME, 		-- NAME
     NULL,
     INSTANCE, 		-- INSTANCE
     max(LAST_UPDATE_DATE), 	-- LAST_UPDATE_DATE
     LOOKUP_CODE,
     LOOKUP_CODE_PK, 	-- LOOKUP_CODE_PK
     LOOKUP_TYPE,
     NULL,
     TABLE_CODE,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- REQUEST_ID
     NULL, -- OPERATION_CODE
     NULL, -- ERROR_CODE
     'READY'
   from EDW_LOOKUP_CODES_LCV
   where last_update_date between l_push_date_range1 and
				l_push_date_range2
      OR last_update_date is NULL
   group by description, lookup_codes_dp,name, instance,
        user_attribute1, user_attribute2,
        user_attribute3, user_attribute4, user_attribute5,
   	lookup_code, lookup_code_pk, lookup_type, table_code;

Line: 148

   l_rows_inserted := sql%rowcount;

Line: 151

   edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
         ' rows into the staging table');

Line: 159

   EDW_LOOKUP_M_C.g_row_count := EDW_LOOKUP_M_C.g_row_count + l_rows_inserted;