APPS.OKL_PROCESS_STREAMS_PVT SQL Statements

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

Line: 42

SELECT ael_rounding_rule
FROM OKL_SYS_ACCT_OPTS;

Line: 45

SELECT currency_code
FROM okc_k_headers_v
WHERE id = p_contract_id;

Line: 49

SELECT precision
FROM fnd_currencies_vl
WHERE currency_code = l_currency_code
AND enabled_flag = 'Y'
AND NVL(start_date_active, SYSDATE) <= SYSDATE
AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line: 125

	 select cle.id kle_id
     from
	   okc_k_headers_b chr,
	   okc_k_lines_b cle,
       okc_line_styles_b lse,
       okc_k_items cim,
	   okl_strm_type_b sty
     where
            chr.id = p_khr_id
     and    chr.id = cle.dnz_chr_id
	 and    cle.lse_id = lse.id
     and    lse.lty_code = 'FEE'
     and    cim.cle_id = cle.id
     and    cim.dnz_chr_id = cle.dnz_chr_id
     and    sty.code        = 'SECURITY DEPOSIT'
     and    cim.object1_id1 = sty.id;

Line: 142

	 SELECT
      KHRB.ID                CHR_ID,
      KHRB.CONTRACT_NUMBER   CONTRACT_NUMBER,
      KLIN.ID                SERVICE_FEE_ID,
      CRLB.OBJECT1_ID1       STY_ID,
      CRGB.ID                RULE_GROUP_ID,
      CRLB.ID                SLH_ID
    FROM
      OKC_K_HEADERS_B KHRB,
      OKC_RULE_GROUPS_B CRGB,
      OKC_RULES_B CRLB,
      OKC_K_LINES_V KLIN,
	  OKL_STRM_TYPE_B STYB
    WHERE
	  KHRB.ID                               = p_khr_id
      AND CRGB.DNZ_CHR_ID                   = KHRB.ID
      AND CRGB.RGD_CODE                     = 'LALEVL'
      AND CRLB.RULE_INFORMATION_CATEGORY    = 'SLH'
      AND CRLB.RGP_ID                       = CRGB.ID
      AND KLIN.ID                           = p_kle_id
      AND CRGB.CLE_ID                       = KLIN.ID
	  AND STYB.CODE                         = 'SECURITY DEPOSIT'
	  AND STYB.ID                           = CRLB.OBJECT1_ID1;

Line: 171

    SELECT CRLB.ID SLL_ID,
           CRLB.OBJECT1_ID1,
           CRLB.RULE_INFORMATION1,
           CRLB.RULE_INFORMATION2,
           CRLB.RULE_INFORMATION3,
           CRLB.RULE_INFORMATION5,

           CRLB.RULE_INFORMATION6,
           CRLB.RULE_INFORMATION10
    FROM   OKC_RULE_GROUPS_B CRGB,
           OKC_RULES_B CRLB
    WHERE  CRGB.ID = slh_id
	       AND CRLB.RGP_ID = CRGB.ID
           AND CRGB.RGD_CODE = RGCODE
           AND CRLB.RULE_INFORMATION_CATEGORY = RLCAT
           AND CRGB.DNZ_CHR_ID = CHRID
    ORDER BY CRLB.RULE_INFORMATION1;

Line: 210

	 -- select the Rule Group ID ( SLH_ID) for SERVICE AND MAINTAINCE LINE
     FOR rule_grp_data_csr in rule_grp_csr(p_khr_id, l_kle_id)
	 LOOP
       l_slh_id := rule_grp_data_csr.RULE_GROUP_ID;

Line: 373

	 SELECT
      KHRB.ID                CHR_ID,
      KHRB.CONTRACT_NUMBER   CONTRACT_NUMBER,
      KLIN.ID                SERVICE_FEE_ID,
      CRLB.OBJECT1_ID1       STY_ID,
      CRGB.ID                RULE_GROUP_ID,
      CRLB.ID                SLH_ID
    FROM
      OKC_K_HEADERS_B KHRB,
      OKC_RULE_GROUPS_B CRGB,
      OKC_RULES_B CRLB,
      OKC_K_LINES_V KLIN,
      OKC_LINE_STYLES_V LSTL
    WHERE
	  KHRB.ID                               = p_khr_id
      AND CRGB.DNZ_CHR_ID                   = KHRB.ID
      AND CRGB.RGD_CODE                     = 'LALEVL'
      AND CRLB.RULE_INFORMATION_CATEGORY    = 'SLH'
      AND CRLB.RGP_ID                       = CRGB.ID
      AND CRGB.CLE_ID                       = KLIN.ID
      AND KLIN.LSE_ID                       = LSTL.ID
      AND LSTL.LTY_CODE                     = 'SOLD_SERVICE'
      --smahapat 03/04/03 bug 2823581
      AND KLIN.STS_CODE IN ('PASSED','COMPLETE');

Line: 403

    SELECT CRLB.ID SLL_ID,
           CRLB.OBJECT1_ID1,
           CRLB.RULE_INFORMATION1,

           CRLB.RULE_INFORMATION2,
           CRLB.RULE_INFORMATION3,
           CRLB.RULE_INFORMATION5,
           CRLB.RULE_INFORMATION6,
           CRLB.RULE_INFORMATION10
    FROM   OKC_RULE_GROUPS_B CRGB,
           OKC_RULES_B CRLB
    WHERE  CRGB.ID = slh_id
	       AND CRLB.RGP_ID = CRGB.ID
           AND CRGB.RGD_CODE = RGCODE
           AND CRLB.RULE_INFORMATION_CATEGORY = RLCAT
           AND CRGB.DNZ_CHR_ID = CHRID
    ORDER BY CRLB.RULE_INFORMATION1;

Line: 491

               l_selv_tbl.delete;

Line: 637

SELECT
    STREAM_TYPE.CODE,
    RETURN_STREAMS.SEQUENCE_NUMBER,
    RETURN_STREAMS.SRE_DATE,
    RETURN_STREAMS.AMOUNT,
    RETURN_STREAMS.INDEX_NUMBER ASSET_INDEX_NUMBER,
    STREAM_TYPE.ID stream_type_id,
    HEADER.KHR_ID,
    TO_NUMBER(NULL) KLE_ID
FROM
  OKL_SIF_RET_STRMS RETURN_STREAMS,
  OKL_SIF_RETS RETURN_HEADER,
  OKL_STRM_TYPE_B STREAM_TYPE,
  OKL_STREAM_INTERFACES HEADER
WHERE
  RETURN_HEADER.id  = RETURN_STREAMS.sir_id
AND RETURN_HEADER.transaction_number  =p_trx_number
AND RETURN_STREAMS.stream_type_name = STREAM_TYPE.CODE
AND HEADER.transaction_number = p_trx_number
AND HEADER.transaction_number = RETURN_HEADER.transaction_number
AND RETURN_STREAMS.index_number IS NULL
AND SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
UNION ALL
-- contract level fees
  SELECT distinct
    STREAM_TYPE.CODE,
    RETURN_STREAMS.SEQUENCE_NUMBER,
    RETURN_STREAMS.SRE_DATE,
    RETURN_STREAMS.AMOUNT,
    RETURN_STREAMS.INDEX_NUMBER ASSET_INDEX_NUMBER,
    STREAM_TYPE.ID stream_type_id,
    HEADER.KHR_ID,
-- added akjain 06-13-2002
-- select kle_fee_id as well from the OKL_SIF_FEES table
    FEES.KLE_ID KLE_ID
--    TO_NUMBER(NULL)
  FROM
    OKL_STRM_TYPE_B STREAM_TYPE,
    OKL_SIF_RET_STRMS RETURN_STREAMS,
    OKL_SIF_RETS RETURN_HEADER,
    OKL_STREAM_INTERFACES HEADER,
--    OKL_SIF_LINES LINES,
    OKL_SIF_FEES  FEES
  WHERE
    RETURN_HEADER.transaction_number  = p_trx_number
  AND
     RETURN_HEADER.id  = RETURN_STREAMS.sir_id
    AND
  RETURN_STREAMS.stream_type_name = STREAM_TYPE.CODE
  AND RETURN_STREAMS.index_number = FEES.fee_index_number
  AND
        FEES.SIL_ID IS NULL
  --Modified by kthiruva on 05-May-2005 for the backporting of mainline bug 4294425
  --Start of Changes
  --AND FEES.DESCRIPTION = RETURN_STREAMS.STREAM_TYPE_NAME
  --End of Changes
--srsreeni Bug 5890437 start
 -- added for bug # 2498794
-- AND (FEES.LEVEL_INDEX_NUMBER = 0 OR (FEES.LEVEL_INDEX_NUMBER IS NULL OR FEES.SFE_TYPE = 'SFO'))
--srsreeni Bug 5890437 end
 AND
        FEES.sif_id = 	HEADER.id
    AND
    HEADER.transaction_number = p_trx_number
   AND HEADER.transaction_number = RETURN_HEADER.transaction_number
    AND SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
  -- Added by kthiruva on 05-May-2005 for the backporting of mainline Bug 4294425
  -- Start of Changes
     AND EXISTS(
      SELECT 1
      FROM
            OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
      WHERE
             REQUESTED_STREAMS.sfe_id = fees.id
      AND REQUESTED_STREAMS.sil_id is NULL
      AND stream_type.id = REQUESTED_STREAMS.sty_id
      AND HEADER.ID = REQUESTED_STREAMS.sif_id ) --dkagrawa added for bug# 4638281
  --End of Changes
UNION ALL
-- asset level streams
  SELECT distinct
    STREAM_TYPE.CODE,
    RETURN_STREAMS.SEQUENCE_NUMBER,
    RETURN_STREAMS.SRE_DATE,
    RETURN_STREAMS.AMOUNT,
    RETURN_STREAMS.INDEX_NUMBER ASSET_INDEX_NUMBER,
    STREAM_TYPE.ID stream_type_id,
    HEADER.KHR_ID,

    LINES.KLE_ID  KLE_ID
  FROM
    OKL_STRM_TYPE_B STREAM_TYPE,
    OKL_SIF_RET_STRMS RETURN_STREAMS,
    OKL_SIF_RETS RETURN_HEADER,
    OKL_STREAM_INTERFACES HEADER,
    OKL_SIF_LINES LINES,
    OKL_SIF_FEES  FEES
  WHERE
    RETURN_HEADER.transaction_number  = p_trx_number
  AND
     RETURN_HEADER.id  = RETURN_STREAMS.sir_id
 --Modified by kthiruva on 12-May-2005 for Streams Performance
 --Bug 4346646 - Start of changes
 AND FEES.DESCRIPTION = STREAM_TYPE.CODE
 --Bug 4346646 - End of Changes
 AND RETURN_STREAMS.index_number =  FEES.fee_index_number
 AND FEES.DESCRIPTION = RETURN_STREAMS.STREAM_TYPE_NAME
  AND
        FEES.SIL_ID = LINES.ID
    AND
    HEADER.transaction_number = p_trx_number
    AND  HEADER.transaction_number = RETURN_HEADER.transaction_number
  AND
	  LINES.SIF_ID = 	HEADER.ID
    AND SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
     AND EXISTS(
      SELECT 1
      FROM
            OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
      WHERE
             REQUESTED_STREAMS.sfe_id = fees.id
      AND stream_type.id = REQUESTED_STREAMS.sty_id
      AND HEADER.ID = REQUESTED_STREAMS.sif_id
      AND ( REQUESTED_STREAMS.sil_id IS NULL OR LINES.ID = REQUESTED_STREAMS.sil_id )
      )
-- added for bare Asset level streams
UNION ALL
SELECT distinct
      STREAM_TYPE.CODE,
      RETURN_STREAMS.SEQUENCE_NUMBER,
      RETURN_STREAMS.SRE_DATE,
      RETURN_STREAMS.AMOUNT,
      RETURN_STREAMS.INDEX_NUMBER ASSET_INDEX_NUMBER,
      STREAM_TYPE.ID stream_type_id,
      HEADER.KHR_ID,
      LINES.KLE_ID  KLE_ID
    FROM
      OKL_STRM_TYPE_B STREAM_TYPE,
      OKL_SIF_RET_STRMS RETURN_STREAMS,
      OKL_SIF_RETS RETURN_HEADER,
      OKL_STREAM_INTERFACES HEADER,
      OKL_SIF_LINES LINES
    WHERE
     RETURN_HEADER.transaction_number  = p_trx_number
    AND
     HEADER.transaction_number = p_trx_number
    AND HEADER.transaction_number = RETURN_HEADER.transaction_number
    AND
      LINES.SIF_ID =         HEADER.ID
    AND
       RETURN_HEADER.id  = RETURN_STREAMS.sir_id
    AND
       RETURN_STREAMS.stream_type_name = STREAM_TYPE.CODE
    --Added by RGOOTY for bug 9004849
    AND
       STREAM_TYPE.STREAM_TYPE_PURPOSE <> 'ESTIMATED_PROPERTY_TAX'
    --end RGOOTY
    AND
       RETURN_STREAMS.index_number =  LINES.index_number
    AND
       SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
and exists(
select 1
from
          OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
where
           REQUESTED_STREAMS.sil_id = lines.id
and REQUESTED_STREAMS.sfe_id is NULL
and stream_type.id = REQUESTED_STREAMS.sty_id)
--Added by RGOOTY for bug 9004849
--Estimated Property Tax streams
UNION ALL
SELECT distinct
      STREAM_TYPE.CODE,
      RETURN_STREAMS.SEQUENCE_NUMBER,
      RETURN_STREAMS.SRE_DATE,
      RETURN_STREAMS.AMOUNT,
      LINES.INDEX_NUMBER ASSET_INDEX_NUMBER,
      STREAM_TYPE.ID stream_type_id,
      HEADER.KHR_ID,
      LINES.KLE_ID  KLE_ID
    FROM
      OKL_STRM_TYPE_B STREAM_TYPE,
      OKL_SIF_RET_STRMS RETURN_STREAMS,
      OKL_SIF_RETS RETURN_HEADER,
      OKL_STREAM_INTERFACES HEADER,
      OKL_SIF_LINES LINES,
      OKL_SIF_FEES  FEES
    WHERE
     RETURN_HEADER.transaction_number  = p_trx_number
    AND
     HEADER.transaction_number = p_trx_number
    AND HEADER.transaction_number = RETURN_HEADER.transaction_number
    AND
      LINES.SIF_ID =         HEADER.ID
    AND
       RETURN_HEADER.id  = RETURN_STREAMS.sir_id
    AND
       RETURN_STREAMS.stream_type_name = STREAM_TYPE.CODE
    AND
       STREAM_TYPE.STREAM_TYPE_PURPOSE = 'ESTIMATED_PROPERTY_TAX'
    AND
       RETURN_STREAMS.index_number =  FEES.FEE_index_number
    AND
       FEES.SIL_ID = LINES.ID
    AND
       STREAM_TYPE.STREAM_TYPE_PURPOSE = FEES.DESCRIPTION
    AND
       SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
and exists(
select 1
from
          OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
where
           REQUESTED_STREAMS.sil_id = lines.id
and REQUESTED_STREAMS.sfe_id is NULL
and stream_type.id = REQUESTED_STREAMS.sty_id)
--end RGOOTY for bug 9004849
   -- Begin mansrini for Bug 5111058 (Fwd port Bug 5061024)
   -- This query will pick the primary streams of purpose Subsidy
   UNION ALL
     SELECT distinct
       STREAM_TYPE.CODE,
       RETURN_STREAMS.SEQUENCE_NUMBER,
       RETURN_STREAMS.SRE_DATE,
       RETURN_STREAMS.AMOUNT,
       RETURN_STREAMS.INDEX_NUMBER ASSET_INDEX_NUMBER,
       STREAM_TYPE.ID stream_type_id,
       HEADER.KHR_ID,

       LINES.KLE_ID  KLE_ID
     FROM
       OKL_STRM_TYPE_B STREAM_TYPE,
       OKL_SIF_RET_STRMS RETURN_STREAMS,
       OKL_SIF_RETS RETURN_HEADER,
       OKL_STREAM_INTERFACES HEADER,
       OKL_SIF_LINES LINES,
       OKL_SIF_FEES  FEES
     WHERE
        RETURN_HEADER.transaction_number  = p_trx_number
     AND
        RETURN_HEADER.id  = RETURN_STREAMS.sir_id
     AND
        RETURN_STREAMS.index_number =  FEES.fee_index_number
     AND
        FEES.SIL_ID = LINES.ID
     AND
        HEADER.transaction_number = RETURN_HEADER.transaction_number
     AND
        LINES.SIF_ID =     HEADER.ID
     AND
        STREAM_TYPE.CODE = RETURN_STREAMS.STREAM_TYPE_NAME
     AND
        STREAM_TYPE.STREAM_TYPE_PURPOSE = 'SUBSIDY'
     AND
        SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
     AND EXISTS(
         SELECT 1
         FROM
               OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
         WHERE
                REQUESTED_STREAMS.sfe_id = fees.id
         AND stream_type.id = REQUESTED_STREAMS.sty_id
         AND HEADER.ID = REQUESTED_STREAMS.sif_id
         AND (REQUESTED_STREAMS.sil_id IS NULL OR LINES.ID = REQUESTED_STREAMS.sil_id)
         )
   -- end mansrini for Bug 5111058 (Fwd port Bug 5061024)

    ORDER BY  stream_type_id, ASSET_INDEX_NUMBER, kle_id;

Line: 909

  SELECT
    YIELD_NAME,
    EFFECTIVE_PRE_TAX_YIELD,
	EFFECTIVE_AFTER_TAX_YIELD,
	NOMINAL_PRE_TAX_YIELD,
	NOMINAL_AFTER_TAX_YIELD,
    IMPLICIT_INTEREST_RATE
  FROM
    OKL_SIF_RETS
  WHERE
    transaction_number = p_trx_number;

Line: 923

  SELECT
  SRMB.ID,
  SRMB.ERROR_CODE,
  SRMB.ERROR_MESSAGE,
  SRMB.TAG_NAME,
  SRMB.TAG_ATTRIBUTE_NAME,
  SRMB.TAG_ATTRIBUTE_VALUE,
  SRMB.DESCRIPTION
  FROM
  OKL_SIF_RETS SIRB,
  OKL_SIF_RET_ERRORS SRMB
  WHERE
  SIRB.TRANSACTION_NUMBER = p_trx_number
  AND
  SIRB.ID = SRMB.SIR_ID;

Line: 940

    SELECT

            ID,
			ORP_CODE,
		        LOG_FILE,
		        SECURITY_DEPOSIT_AMOUNT
      FROM Okl_Stream_Interfaces
     WHERE okl_stream_interfaces.transaction_number = p_transaction_number;

Line: 949

    SELECT
            ID,
            TRANSACTION_NUMBER,
            SRT_CODE,
            EFFECTIVE_PRE_TAX_YIELD,
            YIELD_NAME,
            INDEX_NUMBER,
            EFFECTIVE_AFTER_TAX_YIELD,
            NOMINAL_PRE_TAX_YIELD,
            NOMINAL_AFTER_TAX_YIELD,
			STREAM_INTERFACE_ATTRIBUTE01,
			STREAM_INTERFACE_ATTRIBUTE02,
			STREAM_INTERFACE_ATTRIBUTE03,
			STREAM_INTERFACE_ATTRIBUTE04,
			STREAM_INTERFACE_ATTRIBUTE05,
			STREAM_INTERFACE_ATTRIBUTE06,
			STREAM_INTERFACE_ATTRIBUTE07,
			STREAM_INTERFACE_ATTRIBUTE08,
			STREAM_INTERFACE_ATTRIBUTE09,
			STREAM_INTERFACE_ATTRIBUTE10,
			STREAM_INTERFACE_ATTRIBUTE11,
			STREAM_INTERFACE_ATTRIBUTE12,
			STREAM_INTERFACE_ATTRIBUTE13,
			STREAM_INTERFACE_ATTRIBUTE14,
   			STREAM_INTERFACE_ATTRIBUTE15,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            IMPLICIT_INTEREST_RATE,
            DATE_PROCESSED,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE
      FROM Okl_Sif_Rets
     WHERE okl_sif_rets.transaction_number   = p_trnsaction_numner;

Line: 990

  SELECT purpose_code
    FROM okl_stream_interfaces
	WHERE transaction_number = p_trx_number;

Line: 995

   SELECT c.reporting_pdt_id
     FROM okl_k_headers a, okl_stream_interfaces b, okl_products_v c
         WHERE b.transaction_number = p_trx_number
         AND a.id = b.khr_id
         AND c.id = a.pdt_id;

Line: 1007

SELECT
'1'
FROM
  OKL_SIF_FEES SFEB,
  OKL_STREAM_INTERFACES SIFB
WHERE
  SIFB.ID = SFEB.SIF_ID AND
  transaction_number = p_trx_number AND
  SFE_TYPE = 'SFB' ORDER BY FEE_INDEX_NUMBER;

Line: 1030

    SELECT authoring_org_id,
           currency_code
    FROM okc_k_headers_b
    WHERE id = p_chr_id;

Line: 1037

      SELECT PRECISION
      FROM fnd_currencies_vl
      WHERE currency_code = p_currency_code
        AND enabled_flag = 'Y'
        AND NVL(start_date_active, SYSDATE) <= SYSDATE
        AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line: 1046

      SELECT stm_rounding_rule
      FROM OKL_SYS_ACCT_OPTS;

Line: 1051

    SELECT b.stm_apply_rounding_difference
    FROM fnd_lookups a,
         OKL_SYS_ACCT_OPTS b
    WHERE a.lookup_type = p_lookup_type
    AND a.lookup_code = b.stm_apply_rounding_difference;

Line: 1061

  SELECT 1
  FROM OKC_K_HEADERS_B KHR,
       OKC_K_LINES_B CLE,
       OKC_LINE_STYLES_B LSE
  WHERE CLE.CHR_ID = KHR.ID
  AND  KHR.ID = p_khr_id
  AND  CLE.LSE_ID = LSE.ID
  AND  LSE.LTY_CODE IN ('SOLD_SERVICE','LINK_SERV_ASSET');

Line: 1711

    Okl_la_Stream_Pub.update_contract_yields(p_api_version,
                                           p_init_msg_list ,
                                           x_return_status ,
                                           x_msg_count,
                                           x_msg_data,
                                           l_khr_id ,
                                           l_khr_yields_rec);

Line: 1741

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

Line: 1746

              OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_SIF_RETS_PUB.update_sif_rets');

Line: 1748

	  OKL_SIF_RETS_PUB.update_sif_rets(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_sirv_rec      => l_sirv_rec,
                                     x_sirv_rec      => p_sirv_rec);

Line: 1757

            OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_SIF_RETS_PUB.update_sif_rets, return status is :'|| x_return_status);

Line: 1762

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

Line: 1786

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

Line: 1791

          OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');

Line: 1793

    OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
	                    	        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_sifv_rec => lp_sifv_rec
	 	                           ,x_sifv_rec => lx_sifv_rec);

Line: 1803

            OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces, return status is :'|| x_return_status);

Line: 1808

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

Line: 1863

PROCEDURE UPDATE_STREAMS_ACTIVITY(p_api_version        IN     NUMBER
                                 ,p_init_msg_list      IN     VARCHAR2
                                 ,x_return_status      OUT    NOCOPY VARCHAR2
                                 ,x_msg_count          OUT    NOCOPY NUMBER
                                 ,x_msg_data           OUT    NOCOPY VARCHAR2
	                             ,p_khr_id             IN     NUMBER)
IS
  l_api_name          CONSTANT VARCHAR2(40) := 'UPDATE_STREAMS_ACTIVITY';

Line: 1878

 SELECT
   ID,

   SAY_CODE
 FROM
   OKL_STREAMS_V
 WHERE
   KHR_ID = l_khr_id
 AND
   SAY_CODE = G_STREAM_ACTIVITY_WORK;

Line: 1907

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');

Line: 1910

  Okl_Streams_Pub.update_streams(l_api_version
                                ,p_init_msg_list
                                ,x_return_status
                                ,x_msg_count
                                ,x_msg_data
                                ,stmv_tbl
                                ,x_stmv_tbl);

Line: 1919

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call Okl_Streams_Pub.update_streams ');

Line: 1938

END UPDATE_STREAMS_ACTIVITY;

Line: 1952

    SELECT
      SRMB.ID,
      SRMB.ERROR_CODE,
      SRMB.ERROR_MESSAGE,
      SRMB.TAG_NAME,
      SRMB.TAG_ATTRIBUTE_NAME,
      SRMB.TAG_ATTRIBUTE_VALUE,
      SRMB.DESCRIPTION
    FROM
      OKL_SIF_RETS SIRB,
      OKL_SIF_RET_ERRORS SRMB
    WHERE
      SIRB.TRANSACTION_NUMBER = p_trx_number
    AND
      SIRB.ID = SRMB.SIR_ID;

Line: 2033

  PROCEDURE UPDATE_STATUSES(p_transaction_number NUMBER
	                       ,x_return_status VARCHAR2
  ) IS
    lp_sirv_rec           sirv_rec_type;

Line: 2047

    SELECT
      ID,
      TRANSACTION_NUMBER,
      SRT_CODE,
      EFFECTIVE_PRE_TAX_YIELD,
      YIELD_NAME,
      INDEX_NUMBER,
      EFFECTIVE_AFTER_TAX_YIELD,
      NOMINAL_PRE_TAX_YIELD,
      NOMINAL_AFTER_TAX_YIELD,
	  STREAM_INTERFACE_ATTRIBUTE01,
	  STREAM_INTERFACE_ATTRIBUTE02,
      STREAM_INTERFACE_ATTRIBUTE03,
      STREAM_INTERFACE_ATTRIBUTE04,
	  STREAM_INTERFACE_ATTRIBUTE05,
	  STREAM_INTERFACE_ATTRIBUTE06,
	  STREAM_INTERFACE_ATTRIBUTE07,
	  STREAM_INTERFACE_ATTRIBUTE08,
	  STREAM_INTERFACE_ATTRIBUTE09,
	  STREAM_INTERFACE_ATTRIBUTE10,
	  STREAM_INTERFACE_ATTRIBUTE11,
	  STREAM_INTERFACE_ATTRIBUTE12,
	  STREAM_INTERFACE_ATTRIBUTE13,
	  STREAM_INTERFACE_ATTRIBUTE14,
	  STREAM_INTERFACE_ATTRIBUTE15,
	  OBJECT_VERSION_NUMBER,
	  CREATED_BY,
	  LAST_UPDATED_BY,
	  CREATION_DATE,
	  LAST_UPDATE_DATE,
	  LAST_UPDATE_LOGIN,
	  IMPLICIT_INTEREST_RATE,
	  DATE_PROCESSED,

	  REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE
    FROM Okl_Sif_Rets
    WHERE okl_sif_rets.transaction_number = p_trx_number;

Line: 2088

    SELECT
      ID,
	  ORP_CODE,
	  LOG_FILE
    FROM Okl_Stream_Interfaces
    WHERE okl_stream_interfaces.transaction_number = p_transaction_number;

Line: 2096

    	SELECT
          SRMB.ID
        FROM
          OKL_SIF_RETS SIRB,
          OKL_SIF_RET_ERRORS SRMB
        WHERE
          SIRB.TRANSACTION_NUMBER = p_trx_number
        AND
          SIRB.ID = SRMB.SIR_ID;

Line: 2130

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

Line: 2133

      OKL_SIF_RETS_PUB.update_sif_rets(p_api_version   => lp_api_version,
                                       p_init_msg_list => lp_init_msg_list,
                                       x_return_status => l_return_status,
                                       x_msg_count     => lx_msg_count,
                                       x_msg_data      => lx_msg_data,
                                       p_sirv_rec      => lp_sirv_rec,
                                       x_sirv_rec      => lx_sirv_rec);

Line: 2142

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

Line: 2170

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

Line: 2173

    OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
                                                      ,p_init_msg_list => lp_init_msg_list
                                                      ,x_return_status => l_return_status
                                                      ,x_msg_count => lx_msg_count
                                                      ,x_msg_data => lx_msg_data
                                                      ,p_sifv_rec => lp_sifv_rec
                                                      ,x_sifv_rec => lx_sifv_rec);

Line: 2183

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

Line: 2192

  END UPDATE_STATUSES;

Line: 2214

  	SELECT
  	  ID
  	FROM okl_sif_rets
  	WHERE okl_sif_rets.transaction_number = p_trx_number
  	AND
  	INDEX_NUMBER = 0;

Line: 2221

  	SELECT
        ID,
  	  LEVEL_INDEX_NUMBER,
  	  NUMBER_OF_PERIODS,
  	  SIR_ID,
  	  INDEX_NUMBER,
  	  LEVEL_TYPE,
  	  AMOUNT,
  	  ADVANCE_OR_ARREARS,
  	  PERIOD,
  	  LOCK_LEVEL_STEP,
  	  DAYS_IN_PERIOD,
  	  FIRST_PAYMENT_DATE,
  	  STREAM_INTERFACE_ATTRIBUTE1,
  	  STREAM_INTERFACE_ATTRIBUTE2,
  	  STREAM_INTERFACE_ATTRIBUTE3,
  	  STREAM_INTERFACE_ATTRIBUTE4,
  	  STREAM_INTERFACE_ATTRIBUTE5,
  	  STREAM_INTERFACE_ATTRIBUTE6,
  	  STREAM_INTERFACE_ATTRIBUTE7,
  	  STREAM_INTERFACE_ATTRIBUTE8,
  	  STREAM_INTERFACE_ATTRIBUTE9,
  	  STREAM_INTERFACE_ATTRIBUTE10,
  	  STREAM_INTERFACE_ATTRIBUTE11,
  	  STREAM_INTERFACE_ATTRIBUTE12,
  	  STREAM_INTERFACE_ATTRIBUTE13,
  	  STREAM_INTERFACE_ATTRIBUTE14,
  	  STREAM_INTERFACE_ATTRIBUTE15
  	FROM OKL_SIF_RET_LEVELS
  	WHERE SIR_ID = p_sir_id;

Line: 2252

  	SELECT
          SIRB.EFFECTIVE_PRE_TAX_YIELD,
  	  SIRB.EFFECTIVE_AFTER_TAX_YIELD,
  	  SIRB.NOMINAL_PRE_TAX_YIELD,
  	  SIRB.NOMINAL_AFTER_TAX_YIELD,
        SIRB.IMPLICIT_INTEREST_RATE,
        SIYB.YIELD_NAME,
        SIYB.METHOD,
  	  SIYB.ARRAY_TYPE,
  	  SIYB.ROE_TYPE,
  	  SIYB.ROE_BASE,
        SIYB.COMPOUNDED_METHOD,
  	  SIYB.TARGET_VALUE,
  	  SIYB.INDEX_NUMBER,
  	  SIYB.NOMINAL_YN,
        SIYB.PRE_TAX_YN
  	FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB
  	WHERE SIRB.TRANSACTION_NUMBER = p_trx_number
  	AND SIFB.TRANSACTION_NUMBER = p_trx_number
  	AND SIYB.SIF_ID = SIFB.ID
  	AND SIRB.INDEX_NUMBER = SIYB.INDEX_NUMBER;

Line: 2274

  	SELECT
  	  SIFB.OBJECT1_ID1,
  	  SIFB.KHR_ID
  	FROM
  	  OKL_STREAM_INTERFACES SIFB
  	WHERE

  	  SIFB.TRANSACTION_NUMBER = p_trx_number;

Line: 2403

  	UPDATE_STATUSES(p_transaction_number => p_transaction_number
  	                ,x_return_status      => l_return_status);

Line: 2457

  	SELECT
  	  ID
  	FROM okl_sif_rets
  	WHERE okl_sif_rets.transaction_number = p_trx_number
  	AND INDEX_NUMBER = 0;

Line: 2463

  	SELECT
        ID,
  	  LEVEL_INDEX_NUMBER,
  	  NUMBER_OF_PERIODS,
  	  SIR_ID,
  	  INDEX_NUMBER,
  	  LEVEL_TYPE,
  	  AMOUNT,
  	  ADVANCE_OR_ARREARS,
  	  PERIOD,
  	  LOCK_LEVEL_STEP,
  	  DAYS_IN_PERIOD,
  	  FIRST_PAYMENT_DATE,
  	  STREAM_INTERFACE_ATTRIBUTE1,
  	  STREAM_INTERFACE_ATTRIBUTE2,
  	  STREAM_INTERFACE_ATTRIBUTE3,
  	  STREAM_INTERFACE_ATTRIBUTE4,

  	  STREAM_INTERFACE_ATTRIBUTE5,
  	  STREAM_INTERFACE_ATTRIBUTE6,
  	  STREAM_INTERFACE_ATTRIBUTE7,
  	  STREAM_INTERFACE_ATTRIBUTE8,
  	  STREAM_INTERFACE_ATTRIBUTE9,
  	  STREAM_INTERFACE_ATTRIBUTE10,
  	  STREAM_INTERFACE_ATTRIBUTE11,
  	  STREAM_INTERFACE_ATTRIBUTE12,
  	  STREAM_INTERFACE_ATTRIBUTE13,
  	  STREAM_INTERFACE_ATTRIBUTE14,
  	  STREAM_INTERFACE_ATTRIBUTE15
  	FROM OKL_SIF_RET_LEVELS
  	WHERE SIR_ID = p_sir_id;

Line: 2495

  	SELECT
          SIRB.EFFECTIVE_PRE_TAX_YIELD,
  	  SIRB.EFFECTIVE_AFTER_TAX_YIELD,
  	  SIRB.NOMINAL_PRE_TAX_YIELD,
  	  SIRB.NOMINAL_AFTER_TAX_YIELD,
        SIRB.IMPLICIT_INTEREST_RATE,
        SIYB.YIELD_NAME,
          SIYB.METHOD,
  	  SIYB.ARRAY_TYPE,
  	  SIYB.ROE_TYPE,
  	  SIYB.ROE_BASE,
        SIYB.COMPOUNDED_METHOD,
  	  SIYB.TARGET_VALUE,
  	  SIYB.INDEX_NUMBER,
  	  SIYB.NOMINAL_YN,
        SIYB.PRE_TAX_YN
  	FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB
  	WHERE SIRB.TRANSACTION_NUMBER = p_trx_number
  	AND SIFB.TRANSACTION_NUMBER = p_trx_number
  	AND SIYB.SIF_ID = SIFB.ID
  	AND SIRB.INDEX_NUMBER = SIYB.INDEX_NUMBER;

Line: 2517

  	SELECT
  	  SIFB.SIS_CODE,
  	  SIFB.KHR_ID
  	FROM
  	  OKL_STREAM_INTERFACES SIFB
  	WHERE
  	  SIFB.TRANSACTION_NUMBER = p_trx_number;

Line: 2650

  	UPDATE_STATUSES(p_transaction_number => p_transaction_number
  	                ,x_return_status      => l_return_status);

Line: 2712

  	SELECT
      SRLB.ID,
  	  SRLB.LEVEL_INDEX_NUMBER,
  	  SRLB.NUMBER_OF_PERIODS,
  	  SRLB.SIR_ID,
  	  SRLB.INDEX_NUMBER,
  	  SRLB.LEVEL_TYPE,
  	  SRLB.AMOUNT,
  	  SRLB.ADVANCE_OR_ARREARS,
  	  SRLB.PERIOD,
  	  SRLB.LOCK_LEVEL_STEP,
  	  SRLB.DAYS_IN_PERIOD,
  	  SRLB.FIRST_PAYMENT_DATE,
	  SIFB.KHR_ID,
	  SILB.KLE_ID
  	FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,
         OKL_SIF_LINES SILB
  	WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
	AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
	AND SILB.SIF_ID = SIFB.ID
  	AND SRLB.SIR_ID = SIRB.ID
	AND SRLB.INDEX_NUMBER = SILB.INDEX_NUMBER
	AND SRLB.LEVEL_TYPE in ('Payment','Principal')
	AND SRLB.LOCK_LEVEL_STEP = 'N';

Line: 2738

  	SELECT
      OKL_SIF_RET_LEVELS.ID,
  	  OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
  	  OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
  	  OKL_SIF_RET_LEVELS.SIR_ID,
  	  OKL_SIF_RET_LEVELS.INDEX_NUMBER,
  	  OKL_SIF_RET_LEVELS.LEVEL_TYPE,
  	  OKL_SIF_RET_LEVELS.AMOUNT,
  	  OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
  	  OKL_SIF_RET_LEVELS.PERIOD,
  	  OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
  	  OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
  	  OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
  	  OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
  	FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
  	WHERE OKL_SIF_RETS.transaction_number = p_trx_number
  	AND OKL_SIF_RETS.INDEX_NUMBER = 0
  	AND   OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
	AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
	AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';

Line: 2773

  	SELECT
  	  ID
  	FROM okl_sif_rets
  	WHERE okl_sif_rets.transaction_number = p_trx_number;

Line: 2778

  	SELECT
  	  OBJECT1_ID1,
  	  SIS_CODE
  	FROM OKL_STREAM_INTERFACES
  	WHERE TRANSACTION_NUMBER = p_trx_number;

Line: 2792

    SELECT TO_NUMBER(crl.rule_information7) stub_days
    FROM okc_rule_groups_b crg,
       okc_rules_b crl
    WHERE crl.rgp_id = crg.id
    AND crl.object2_id1 = p_slh_id
    AND crg.rgd_code = 'LALEVL'
    AND crl.rule_information_category = 'LASLL'
    AND crg.dnz_chr_id = p_chr_id
    AND crg.cle_id = p_cle_id
    AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;

Line: 2809

    SELECT crl.id slh_id
    FROM okc_rule_groups_b crg,
         okc_rules_b crl
    WHERE crl.rgp_id = crg.id
    AND crg.rgd_code = 'LALEVL'
    AND crl.rule_information_category = 'LASLH'
    AND crg.dnz_chr_id = p_chr_id
    AND crg.cle_id = p_cle_id
    ORDER BY crl.rule_information1;

Line: 2823

    SELECT crl.object1_id1 frequency
    FROM okc_rule_groups_b crg,
       okc_rules_b crl
    WHERE crl.rgp_id = crg.id
    AND crl.object2_id1 = p_slh_id
    AND crg.rgd_code = 'LALEVL'
    AND crl.rule_information_category = 'LASLL'
    AND crg.dnz_chr_id = p_chr_id
    AND crg.cle_id = p_cle_id;

Line: 2863

  	UPDATE_STATUSES(p_transaction_number => p_transaction_number
  	                ,x_return_status      => l_return_status);

Line: 2998

             OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call okl_cs_lease_renewal_pub.update_lrnw_request ');

Line: 3001

           okl_cs_lease_renewal_pub.update_lrnw_request(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_trqv_rec            =>  p_trqv_rec
                                                   ,x_trqv_rec            =>  x_trqv_rec);

Line: 3010

             OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call okl_cs_lease_renewal_pub.update_lrnw_request ');

Line: 3213

  	SELECT
        SRLB.ID,
  	  SRLB.LEVEL_INDEX_NUMBER,
  	  SRLB.NUMBER_OF_PERIODS,
  	  SRLB.SIR_ID,
  	  SRLB.INDEX_NUMBER,
  	  SRLB.LEVEL_TYPE,
  	  SRLB.AMOUNT,
  	  SRLB.ADVANCE_OR_ARREARS,
  	  SRLB.PERIOD,
  	  SRLB.LOCK_LEVEL_STEP,
  	  SRLB.DAYS_IN_PERIOD,
  	  SRLB.FIRST_PAYMENT_DATE,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE1,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE2,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE3,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE4,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE5,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE6,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE7,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE8,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE9,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE10,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE11,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE12,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE13,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE14,
  	  SRLB.STREAM_INTERFACE_ATTRIBUTE15,
      SIFB.KHR_ID,
      SILB.KLE_ID,
      SIFB.ID SIF_ID,
      SILB.ID SIL_ID
    FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,
         OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB
  	WHERE SRLB.SIR_ID = p_sir_id
  	AND  SIFB.TRANSACTION_NUMBER = p_trx_number
	AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
	AND SILB.SIF_ID = SIFB.ID
  	AND SRLB.SIR_ID = SIRB.ID
	AND SRLB.INDEX_NUMBER = SILB.INDEX_NUMBER
    AND SRLB.LEVEL_TYPE IN ('Payment','Principal')
    AND SRLB.LOCK_LEVEL_STEP = 'N'
    ORDER BY KLE_ID,LEVEL_INDEX_NUMBER;

Line: 3258

  	SELECT
  	  ID
  	FROM okl_sif_rets
  	WHERE okl_sif_rets.transaction_number = p_trx_number
  	AND OKL_SIF_RETS.INDEX_NUMBER = 0;

Line: 3264

  	SELECT
  	  SIS_CODE,
  	  KHR_ID
  	FROM OKL_STREAM_INTERFACES
  	WHERE TRANSACTION_NUMBER = p_trx_number;

Line: 3278

    SELECT TO_NUMBER(crl.rule_information7) stub_days
    FROM okc_rule_groups_b crg,
       okc_rules_b crl
    WHERE crl.rgp_id = crg.id
    AND crl.object2_id1 = p_slh_id
    AND crg.rgd_code = 'LALEVL'
    AND crl.rule_information_category = 'LASLL'
    AND crg.dnz_chr_id = p_chr_id
    AND crg.cle_id = p_cle_id
    AND FND_DATE.canonical_to_date(crl.rule_information2)+TO_NUMBER(crl.rule_information7) = p_date;

Line: 3293

    SELECT crl.id slh_id
    FROM okc_rule_groups_b crg,
         okc_rules_b crl
    WHERE crl.rgp_id = crg.id
    AND crg.rgd_code = 'LALEVL'
    AND crl.rule_information_category = 'LASLH'
    AND crg.dnz_chr_id = p_chr_id
    AND crg.cle_id = p_cle_id
    ORDER BY crl.rule_information1;

Line: 3307

    SELECT crl.object1_id1 frequency
    FROM okc_rule_groups_b crg,
       okc_rules_b crl
    WHERE crl.rgp_id = crg.id
    AND crl.object2_id1 = p_slh_id
    AND crg.rgd_code = 'LALEVL'
    AND crl.rule_information_category = 'LASLL'
    AND crg.dnz_chr_id = p_chr_id
    AND crg.cle_id = p_cle_id;

Line: 3328

    SELECT TRUNC(DATE_START)
      FROM OKL_SIF_FEES
     WHERE DESCRIPTION IN('RENT', 'PRINCIPAL_PAYMENT')
       AND LEVEL_INDEX_NUMBER = P_LEVEL_INDX_NUM
       AND SIL_ID = P_SIL_ID
       AND SIF_ID = P_SIF_ID;

Line: 3374

  	UPDATE_STATUSES(p_transaction_number => p_transaction_number
  	                ,x_return_status      => l_return_status);

Line: 3557

  SELECT
    IN_XML
  FROM
    OKL_STREAM_TRX_DATA
  WHERE
  transaction_number = p_trx_number;