APPS.OKL_BPD_MAN_RCT_HANDLE_PVT SQL Statements

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

Line: 114

     CURSOR c_get_gl_date(cp_date IN DATE) IS SELECT * from (
     SELECT trunc(cp_date) gl_date, 1 Counter
     FROM gl_period_statuses
     WHERE application_id = 222
     -- BEGIN abindal bug 4356410 --
     AND closing_status IN ('F','O')
     -- END abindal bug 4356410 --
     AND ledger_id = okl_accounting_util.get_set_of_books_id
     AND trunc(cp_date) between start_date and end_date
     AND adjustment_period_flag = 'N'
     UNION
     SELECT MAX(end_date) gl_date, 2 Counter
     FROM gl_period_statuses
     WHERE application_id = 222
     AND ledger_id = okl_accounting_util.get_set_of_books_id
     AND closing_status IN ('F','O')
     AND end_date <= trunc(cp_date)
     AND adjustment_period_flag = 'N'
     UNION
     SELECT MIN(start_date) gl_date, 3 Counter
     FROM gl_period_statuses
     WHERE application_id = 222
     AND ledger_id = okl_accounting_util.get_set_of_books_id
     AND closing_status IN ('F','O')
     AND start_date >= trunc(cp_date)
     AND adjustment_period_flag = 'N'
     )
     where gl_date is not null
     order by counter;

Line: 146

  SELECT
         RCT.CHECK_NUMBER RECEIPT_NUMBER
       , RCT.RECEIPT_TYPE
       , RCT.AMOUNT
       , NULL ID
    FROM
        OKL_TRX_CSH_RECEIPT_V RCT
--      , OKL_EXT_CSH_RCPTS_V   XCR
   WHERE
--         XCR.RCT_ID = RCT.ID
--     AND XCR.ICR_ID = cp_cash_rcpt_id;

Line: 162

  SELECT   NVL(SUM(AMOUNT_APPLIED),0)
  FROM     AR_RECEIVABLE_APPLICATIONS_ALL
  WHERE    STATUS = 'ACC'
  AND      CASH_RECEIPT_ID = cp_csh_rcpt_id;

Line: 171

  SELECT   NVL(SUM(AMOUNT_APPLIED),0)
  FROM     AR_RECEIVABLE_APPLICATIONS_ALL
  WHERE    STATUS = 'UNAPP'
  AND      CASH_RECEIPT_ID = cp_csh_rcpt_id;

Line: 181

  SELECT   NVL(AMOUNT_APPLIED,0), NVL(RECEIVABLE_APPLICATION_ID,0)
  FROM     AR_RECEIVABLE_APPLICATIONS_ALL
  WHERE    APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
  AND      CASH_RECEIPT_ID = cp_cash_receipt_id
  AND      STATUS = 'APP'
  ORDER BY CREATION_DATE desc;

Line: 191

    SELECT CNSLD.RECEIVABLES_INVOICE_ID
      FROM OKL_CNSLD_AR_STRMS_V CNSLD
     WHERE CNSLD.ID = cp_stream_id;

Line: 198

  SELECT
         APS.AMOUNT_DUE_REMAINING
    FROM
         AR_PAYMENT_SCHEDULES_ALL APS
   WHERE
         APS.CUSTOMER_TRX_ID = cp_customer_trx_id;

Line: 381

          OKL_XCA_PVT.insert_row( p_api_version   => l_api_version
                                 ,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_xcav_rec      => lp_xcav_tbl(i)
                                 ,x_xcav_rec      => lx_xcav_rec
                                );

Line: 550

      OKL_XCR_PUB.UPDATE_EXT_CSH_TXNS( p_api_version   => l_api_version
                                      ,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_xcrv_rec      => lp_xcrv_rec
                                      ,x_xcrv_rec      => lx_xcrv_rec
                                      );

Line: 686

  SELECT
         RCT.CHECK_NUMBER RECEIPT_NUMBER
       , RCT.RECEIPT_TYPE
       , RCT.AMOUNT
       , NULL ID
       ,RCT.CURRENCY_CODE
  FROM
        OKL_TRX_CSH_RECEIPT_V RCT
--      , OKL_EXT_CSH_RCPTS_V   XCR
  WHERE
--         XCR.RCT_ID = RCT.ID
--    AND XCR.ICR_ID = cp_cash_rcpt_id;

Line: 704

  SELECT   NVL(RECEIVABLE_APPLICATION_ID,0)
  FROM     AR_RECEIVABLE_APPLICATIONS_ALL
  WHERE    APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
  AND      CASH_RECEIPT_ID = cp_cash_receipt_id
  AND      STATUS = 'APP'
  ORDER BY CREATION_DATE desc;

Line: 714

  SELECT CNSLD.RECEIVABLES_INVOICE_ID
  FROM   OKL_CNSLD_AR_STRMS_V CNSLD
  WHERE  CNSLD.ID = cp_stream_id;

Line: 721

  SELECT   NVL(SUM(AMOUNT_APPLIED),0)
  FROM     AR_RECEIVABLE_APPLICATIONS_ALL
  WHERE    STATUS = 'APP'
  AND      CASH_RECEIPT_ID = cp_csh_rcpt_id;

Line: 805

       OKL_XCA_PVT.insert_row( p_api_version   => l_api_version
                              ,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_xcav_rec      => lp_xcav_tbl(i)
                              ,x_xcav_rec      => lx_xcav_rec
                             );

Line: 864

      OKL_XCR_PUB.UPDATE_EXT_CSH_TXNS( p_api_version   => l_api_version
                                      ,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_xcrv_rec      => lp_xcrv_rec
                                      ,x_xcrv_rec      => lx_xcrv_rec
                                      );