APPS.OKL_CASH_APPLN_RULE_PVT SQL Statements

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

Line: 41

     SELECT object_version_number
     , name
     FROM OKL_CSH_ALLCTN_RL_HDR
     WHERE id = cp_id;

Line: 47

     SELECT name
     FROM OKL_CSH_ALLCTN_RL_HDR
     WHERE name = cp_name;

Line: 53

     SELECT end_date
     FROM OKL_CASH_ALLCTN_RLS
     WHERE id = cp_id;

Line: 58

     SELECT id
     , object_version_number
     , start_date
     , end_date
     FROM OKL_CASH_ALLCTN_RLS
     WHERE cau_id = cp_cau_id
     ORDER BY id DESC;

Line: 85

       SELECT start_date, end_date
       FROM OKL_CASH_ALLCTN_RLS
       WHERE cau_id = nvl(cp_cau_id, -99)
       AND id <> nvl(cp_id, -99)
       AND (trunc(cp_start_date) between trunc(start_date) and trunc(nvl(end_date, cp_start_date))
            OR trunc(nvl(cp_end_date, cp_start_date)) between trunc(start_date) and trunc(end_date));

Line: 97

       SELECT start_date, end_date
       FROM OKL_CASH_ALLCTN_RLS
       WHERE cau_id = nvl(cp_cau_id, -99)
       AND id <> nvl(cp_id, -99)
       AND (trunc(end_date) < trunc(cp_start_date))
             --OR (nvl(cp_end_date, cp_start_date) < start_date))
       ORDER BY start_date desc;

Line: 110

       SELECT start_date, end_date
       FROM OKL_CASH_ALLCTN_RLS
       WHERE cau_id = nvl(cp_cau_id, -99)
       AND id <> nvl(cp_id, -99)
       AND (trunc(nvl(cp_end_date, cp_start_date)) < trunc(start_date))
       ORDER BY start_date asc;

Line: 194

       SELECT cau_id
       FROM OKL_CASH_ALLCTN_RLS
       WHERE ((NVL(l_catv_rec.cau_id, okl_api.g_miss_num)  = okl_api.g_miss_num) OR
              (l_catv_rec.cau_id IS NOT NULL AND cau_id = cp_cau_id))
       AND default_rule = 'YES';

Line: 296

        okl_csh_allctn_rl_hdr_pub.insert_csh_allctn_rl_hdr(
           p_api_version => p_api_version
          ,p_init_msg_list => p_init_msg_list
          ,x_return_status => l_return_status
          ,x_msg_count => x_msg_count
          ,x_msg_data => x_msg_data
          ,p_cauv_rec => l_cauv_rec
          ,x_cauv_rec => lx_cauv_rec);

Line: 325

        Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(
           p_api_version => p_api_version
          ,p_init_msg_list => p_init_msg_list
          ,x_return_status => l_return_status
          ,x_msg_count => x_msg_count
          ,x_msg_data => x_msg_data
          ,p_catv_rec => l_catv_rec
          ,x_catv_rec => lx_catv_rec);

Line: 374

        okl_csh_allctn_rl_hdr_pub.update_csh_allctn_rl_hdr(
           p_api_version => p_api_version
          ,p_init_msg_list => p_init_msg_list
          ,x_return_status => l_return_status
          ,x_msg_count => x_msg_count
          ,x_msg_data => x_msg_data
          ,p_cauv_rec => l_cauv_rec
          ,x_cauv_rec => lx_cauv_rec);

Line: 391

        Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(
           p_api_version => p_api_version
          ,p_init_msg_list => p_init_msg_list
          ,x_return_status => l_return_status
          ,x_msg_count => x_msg_count
          ,x_msg_data => x_msg_data
          ,p_catv_rec => l_catv_rec
          ,x_catv_rec => lx_catv_rec);

Line: 451

      Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls(
         p_api_version => p_api_version
        ,p_init_msg_list => p_init_msg_list
        ,x_return_status => l_return_status
        ,x_msg_count => x_msg_count
        ,x_msg_data => x_msg_data
        ,p_catv_rec => l_prev_catv_rec
        ,x_catv_rec => lx_prev_catv_rec);

Line: 489

        okl_csh_allctn_rl_hdr_pub.update_csh_allctn_rl_hdr(
           p_api_version => p_api_version
          ,p_init_msg_list => p_init_msg_list
          ,x_return_status => l_return_status
          ,x_msg_count => x_msg_count
          ,x_msg_data => x_msg_data
          ,p_cauv_rec => l_cauv_rec
          ,x_cauv_rec => lx_cauv_rec);

Line: 506

        Okl_Cash_Allctn_Rls_Pub.insert_cash_allctn_rls(
           p_api_version => p_api_version
          ,p_init_msg_list => p_init_msg_list
          ,x_return_status => l_return_status
          ,x_msg_count => x_msg_count
          ,x_msg_data => x_msg_data
          ,p_catv_rec => l_catv_rec
          ,x_catv_rec => lx_catv_rec);

Line: 648

    SELECT DECODE(p_out_field, 'SEQ', TO_CHAR(sequence_number), 'SAT', stream_allc_type, '$' || sequence_number || '$' || stream_allc_type || '$')
    INTO lx_retval from OKL_STRM_TYP_ALLOCS
    WHERE cat_id = p_cat_id
    AND sty_id = p_sty_id
    AND stream_allc_type = p_stream_allc_type;