[Home] [Help]
7845: AND POC.KHR_ID = STMB.KHR_ID
7846: AND POL.KHR_ID = P_CONTRACT_ID
7847: AND POC.STY_ID = STYS.ID
7848: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
7849: AND POC.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
7850: );
7851:
7852: CURSOR c_rent_accrual_pending(p_contract_id okc_k_headers_b.id%TYPE) IS
7853: SELECT NVL(SUM(SELB.AMOUNT),0)
7867: AND POC.KHR_ID = STMB.KHR_ID
7868: AND POL.KHR_ID = P_CONTRACT_ID
7869: AND POC.STY_ID = STYS.ID
7870: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
7871: AND POC.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING);
7872:
7873: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
7874:
7875: BEGIN
8067: AND stmb.say_code = 'CURR'
8068: AND stmb.active_yn = 'Y'
8069: AND selb.STREAM_ELEMENT_DATE
8070: BETWEEN pocb.STREAMS_FROM_DATE AND NVL(pocb.STREAMS_TO_DATE, G_FINAL_DATE)
8071: AND pocb.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING ; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
8072:
8073: -- get pool streams amount by subclass
8074: CURSOR l_streams_amount_pending_csr (p_pol_id NUMBER, p_stm_sub_class VARCHAR2)
8075: IS
8088: AND stmb.say_code = 'CURR'
8089: AND stmb.active_yn = 'Y'
8090: AND selb.STREAM_ELEMENT_DATE
8091: BETWEEN pocb.STREAMS_FROM_DATE AND NVL(pocb.STREAMS_TO_DATE, G_FINAL_DATE)
8092: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING ;
8093:
8094: l_total_percent NUMBER := 0;
8095: l_total_sec_amount NUMBER := 0;
8096: l_per_subclass_amount NUMBER := 0;