APPS.FII_PA_BUDGET_M_C SQL Statements

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

Line: 18

 l_rows_inserted            Number:=0;

Line: 95

    l_rows_inserted NUMBER :=0;

Line: 105

   Insert Into
     FII_PA_PABU_BUDGET_LSTG(
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     INSTANCE,
     CREATION_DATE,
     LAST_UPDATE_DATE,
     BUDGET_PK,
     NAME,
     BUDGET_TYPE,
     VERSION_NAME,
     PROJECT_NAME,
     CURRENT_FLAG,
     ORIGINAL_FLAG,
     CURRENT_ORIGINAL_FLAG,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     INSTANCE,
     SYSDATE,
     SYSDATE,
     BUDGET_PK,
     NAME,
     BUDGET_TYPE,
     VERSION_NAME,
     PROJECT_NAME,
     CURRENT_FLAG,
     ORIGINAL_FLAG,
     CURRENT_ORIGINAL_FLAG,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     NULL,
     'READY'
   from
     FII_PA_PABU_BUDGET_LCV
   where
     last_update_date between l_date1 and l_date2;

Line: 149

   l_rows_inserted := sql%rowcount;

Line: 150

   g_row_count := g_row_count + l_rows_inserted ;