APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_POOLS

Line 7842: OKL_POOLS POL,

7838: AND STMB.SAY_CODE = 'CURR'
7839: AND STMB.ACTIVE_YN = 'Y'
7840: AND EXISTS (SELECT 1
7841: FROM OKL_POOL_CONTENTS POC,
7842: OKL_POOLS POL,
7843: OKL_STRM_TYPE_V STYS
7844: WHERE POC.POL_ID = POL.ID
7845: AND POC.KHR_ID = STMB.KHR_ID
7846: AND POL.KHR_ID = P_CONTRACT_ID

Line 7864: OKL_POOLS POL,

7860: AND STYV.STREAM_TYPE_PURPOSE IN ('INVESTOR_PRETAX_INCOME','INVESTOR_RENTAL_ACCRUAL','INVESTOR_INTEREST_INCOME')
7861: AND STMB.SAY_CODE = 'CURR'
7862: AND STMB.ACTIVE_YN = 'Y'
7863: AND EXISTS (SELECT 1 FROM OKL_POOL_CONTENTS POC,
7864: OKL_POOLS POL,
7865: OKL_STRM_TYPE_V STYS
7866: WHERE POC.POL_ID = POL.ID
7867: AND POC.KHR_ID = STMB.KHR_ID
7868: AND POL.KHR_ID = P_CONTRACT_ID

Line 8030: l_pol_id okl_pools.id%TYPE;

8026: ) RETURN NUMBER
8027: IS
8028:
8029: x_value NUMBER;
8030: l_pol_id okl_pools.id%TYPE;
8031: l_percent_stake NUMBER;
8032: G_FINAL_DATE CONSTANT DATE := TO_DATE('1','j') + 5300000;
8033:
8034:

Line 8037: FROM okl_pools polb

8033:
8034:
8035: CURSOR l_khr_csr(p_khr_id okc_k_headers_b.id%TYPE) IS
8036: SELECT polb.id
8037: FROM okl_pools polb
8038: WHERE polb.khr_id = p_khr_id;
8039:
8040: -- get revenue share by subclass
8041: CURSOR l_okl_percent_stake_csr(p_sty_subclass IN VARCHAR2)