APPS.OKL_SYSTEM_ACCT_OPT_PVT SQL Statements

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

Line: 19

      SELECT MEANING
       FROM  FND_LOOKUPS FND
       WHERE FND.LOOKUP_TYPE = p_lookup_type
         AND FND.LOOKUP_CODE = p_lookup_code;

Line: 61

   l_stmt := '  SELECT ID
          ,CC_REP_CURRENCY_CODE
          ,CODE_COMBINATION_ID
          ,AEL_REP_CURRENCY_CODE
          ,SET_OF_BOOKS_ID
          ,OBJECT_VERSION_NUMBER
          ,REC_CCID
          ,REALIZED_GAIN_CCID
          ,REALIZED_LOSS_CCID
          ,TAX_CCID
          ,CROSS_CURRENCY_CCID
          ,ROUNDING_CCID
          ,AR_CLEARING_CCID
          ,PAYABLES_CCID
          ,LIABLITY_CCID
          ,PRE_PAYMENT_CCID
          ,FUT_DATE_PAY_CCID
          ,CC_ROUNDING_RULE
          ,CC_PRECISION
          ,CC_MIN_ACCT_UNIT
          ,DIS_TAKEN_CCID
          ,AP_CLEARING_CCID
          ,AEL_ROUNDING_RULE
          ,AEL_PRECISION
          ,AEL_MIN_ACCT_UNIT
          ,ORG_ID
          ,ATTRIBUTE_CATEGORY
          ,ATTRIBUTE1
          ,ATTRIBUTE2
          ,ATTRIBUTE3
          ,ATTRIBUTE4
          ,ATTRIBUTE5
          ,ATTRIBUTE6
          ,ATTRIBUTE7
          ,ATTRIBUTE8
          ,ATTRIBUTE9
          ,ATTRIBUTE10
          ,ATTRIBUTE11
          ,ATTRIBUTE12
          ,ATTRIBUTE13
          ,ATTRIBUTE14
          ,ATTRIBUTE15
          ,CREATED_BY
          ,CREATION_DATE
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
          ,CC_APPLY_ROUNDING_DIFFERENCE
          ,AEL_APPLY_ROUNDING_DIFFERENCE
          ,LKE_HOLD_DAYS
          --Added by Keerthi 12-Sep-2003
          ,STM_APPLY_ROUNDING_DIFFERENCE
          ,STM_ROUNDING_RULE
          --Added new field for bug 4884618(H)
          ,VALIDATE_KHR_START_DATE
          ,ACCOUNT_DERIVATION -- R12 SLA Uptake
    FROM OKL_SYS_ACCT_OPTS ';

Line: 166

              ,l_saov_rec.LAST_UPDATED_BY
              ,l_saov_rec.LAST_UPDATE_DATE
              ,l_saov_rec.LAST_UPDATE_LOGIN
              ,l_saov_rec.CC_APPLY_ROUNDING_DIFFERENCE
              ,l_saov_rec.AEL_APPLY_ROUNDING_DIFFERENCE
              ,l_saov_rec.LKE_HOLD_DAYS
              -- Added by Keerthi 10-Sep-2003 for Rounding of Amounts in Streams
              ,l_saov_rec.STM_APPLY_ROUNDING_DIFFERENCE
              ,l_saov_rec.STM_ROUNDING_RULE
              --Added new field for bug 4746246
              ,l_saov_rec.VALIDATE_KHR_START_DATE
              ,l_saov_rec.ACCOUNT_DERIVATION; -- R12 SLA Uptake

Line: 249

        OKL_SYS_ACCT_OPTS_PUB.INSERT_SYS_ACCT_OPTS(p_api_version   => 1.0,
                                                   p_init_msg_list => l_init_msg_list,
                                                   x_return_status => l_return_status,
                                                   x_msg_count     => l_msg_count,
                                                   x_msg_data      => l_msg_data,
                                                   p_saov_rec      => p_saov_rec,
                                                   x_saov_rec      => l_saov_rec_out);

Line: 288

        OKL_SYS_ACCT_OPTS_PUB.UPDATE_SYS_ACCT_OPTS(p_api_version       => 1.0,
                                                   p_init_msg_list     => l_init_msg_list,
                                                   x_return_status     => l_return_status,
                                                   x_msg_count         => l_msg_count,
                                                   x_msg_data          => l_msg_data,
                                                   p_saov_rec          => l_saov_rec_in,
                                                   x_saov_rec          => l_saov_rec_out);