APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_POOLS

Line 8516: OKL_POOLS POL,

8512: AND STMB.SAY_CODE = 'CURR'
8513: AND STMB.ACTIVE_YN = 'Y'
8514: AND EXISTS (SELECT 1
8515: FROM OKL_POOL_CONTENTS POC,
8516: OKL_POOLS POL,
8517: OKL_STRM_TYPE_V STYS
8518: WHERE POC.POL_ID = POL.ID
8519: AND POC.KHR_ID = STMB.KHR_ID
8520: AND POL.KHR_ID = P_CONTRACT_ID

Line 8538: OKL_POOLS POL,

8534: AND STYV.STREAM_TYPE_PURPOSE IN ('INVESTOR_PRETAX_INCOME','INVESTOR_RENTAL_ACCRUAL','INVESTOR_INTEREST_INCOME')
8535: AND STMB.SAY_CODE = 'CURR'
8536: AND STMB.ACTIVE_YN = 'Y'
8537: AND EXISTS (SELECT 1 FROM OKL_POOL_CONTENTS POC,
8538: OKL_POOLS POL,
8539: OKL_STRM_TYPE_V STYS
8540: WHERE POC.POL_ID = POL.ID
8541: AND POC.KHR_ID = STMB.KHR_ID
8542: AND POL.KHR_ID = P_CONTRACT_ID

Line 8704: l_pol_id okl_pools.id%TYPE;

8700: ) RETURN NUMBER
8701: IS
8702:
8703: x_value NUMBER;
8704: l_pol_id okl_pools.id%TYPE;
8705: l_percent_stake NUMBER;
8706: G_FINAL_DATE CONSTANT DATE := TO_DATE('1','j') + 5300000;
8707:
8708:

Line 8711: FROM okl_pools polb

8707:
8708:
8709: CURSOR l_khr_csr(p_khr_id okc_k_headers_b.id%TYPE) IS
8710: SELECT polb.id
8711: FROM okl_pools polb
8712: WHERE polb.khr_id = p_khr_id;
8713:
8714: -- get revenue share by subclass
8715: CURSOR l_okl_percent_stake_csr(p_sty_subclass IN VARCHAR2)