APPS.OKS_AVG_SET_PUB SQL Statements

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

Line: 17

 SELECT currency_code FROM okc_k_headers_b
 WHERE id = p_hdr_id;

Line: 22

 SELECT trunc(date_billed_from) date_billed_from FROM oks_bill_cont_lines
 WHERE  cle_id = p_cle_id
 order by date_billed_to desc;

Line: 29

 SELECT sum(bsd.result)           qty_billed,
        min(bsl.date_billed_from) date_billed_from,
        max(bsl.date_billed_to)   date_billed_to,
        sum(bsl.amount)           amt_billed,
        bsl.cle_id
 FROM
       oks_bill_sub_line_dtls  bsd,
       oks_bill_sub_lines      bsl
 WHERE bsd.bsl_id   =  bsl.id
 AND   bsl.bcl_id in
       (select bcl.id from oks_bill_cont_lines bcl
        where  bcl.averaged_yn  is null
        AND    trunc(bcl.date_billed_from) >= p_date
        and    bcl.cle_id = p_cle_id )
 group by bsl.cle_id;

Line: 49

 SELECT id                     bcl_id
       ,Date_Billed_from       Date_Billed_from
       ,Date_Billed_to         Date_Billed_to
 FROM oks_bill_cont_lines
 Where cle_id = p_cle_id
 AND  trunc(date_billed_from ) >= trunc(p_date_billed_from)
 AND  trunc(date_billed_to ) <= trunc(p_date_billed_to)
 AND  averaged_yn is NULL;

Line: 60

 SELECT  bsd.unit_of_measure    uom_code,
         bsd.amcv_yn            amcv_yn,
         bsl.date_billed_from   date_from,
         bsl.date_billed_to     date_to
    FROM  oks_bill_sub_lines     bsl,
          oks_bill_sub_line_dtls bsd
    WHERE bsl.cle_id = p_cle_id
    AND   bsl.id = bsd.bsl_id
    order by bsl.date_billed_to desc;

Line: 193

       OKS_BILL_REC_PUB.Insert_bcl
               (P_CALLEDFROM        => 1,
                X_RETURN_STAT       => l_return_status,
                P_CLE_ID            => p_cle_id,
                P_DATE_BILLED_FROM  => l_date_from,
                P_DATE_BILLED_TO    => l_date_to,
                P_DATE_NEXT_INVOICE => sysdate,
                P_BILL_ACTION       => 'AV',
                P_OKL_FLAG          => 2,
                P_PRV               => 1,
                P_MSG_COUNT         => l_msg_count,
                P_MSG_DATA          => l_msg_data,
                X_BCL_ID            => l_bcl_id);

Line: 208

         FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');

Line: 216

       OKS_BILL_REC_PUB.Insert_all_subline
             (
              P_CALLEDFROM     => 1,
              X_RETURN_STAT    => l_return_status,
              P_COVERED_TBL    => l_cov_tbl,
              P_CURRENCY_CODE  => l_curr_code,
              P_DNZ_CHR_ID     => p_hdr_id,
              P_PRV            => 1,
              P_MSG_COUNT      => l_msg_count,
              P_MSG_DATA       => l_msg_data
              );

Line: 229

         FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bsl');

Line: 240

    UPDATE oks_bill_cont_lines
    Set averaged_YN = 'Y'
    WHERE cle_id = p_cle_id;

Line: 284

SELECT averaging_interval,
       settlement_interval,
       cle_id
    FROM oks_k_lines_b
    WHERE dnz_chr_id  = p_id
    and averaging_interval is not null;