[Home] [Help]
8519: AND POC.KHR_ID = STMB.KHR_ID
8520: AND POL.KHR_ID = P_CONTRACT_ID
8521: AND POC.STY_ID = STYS.ID
8522: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
8523: AND POC.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
8524: );
8525:
8526: CURSOR c_rent_accrual_pending(p_contract_id okc_k_headers_b.id%TYPE) IS
8527: SELECT NVL(SUM(SELB.AMOUNT),0)
8541: AND POC.KHR_ID = STMB.KHR_ID
8542: AND POL.KHR_ID = P_CONTRACT_ID
8543: AND POC.STY_ID = STYS.ID
8544: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
8545: AND POC.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING);
8546:
8547: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8548:
8549: BEGIN
8741: AND stmb.say_code = 'CURR'
8742: AND stmb.active_yn = 'Y'
8743: AND selb.STREAM_ELEMENT_DATE
8744: BETWEEN pocb.STREAMS_FROM_DATE AND NVL(pocb.STREAMS_TO_DATE, G_FINAL_DATE)
8745: AND pocb.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING ; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
8746:
8747: -- get pool streams amount by subclass
8748: CURSOR l_streams_amount_pending_csr (p_pol_id NUMBER, p_stm_sub_class VARCHAR2)
8749: IS
8762: AND stmb.say_code = 'CURR'
8763: AND stmb.active_yn = 'Y'
8764: AND selb.STREAM_ELEMENT_DATE
8765: BETWEEN pocb.STREAMS_FROM_DATE AND NVL(pocb.STREAMS_TO_DATE, G_FINAL_DATE)
8766: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING ;
8767:
8768: l_total_percent NUMBER := 0;
8769: l_total_sec_amount NUMBER := 0;
8770: l_per_subclass_amount NUMBER := 0;