DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 8227: okl_K_headers_full_v pkhr,

8223: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8224: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8225: from okl_pools pol,
8226: okl_pool_contents pcn,
8227: okl_K_headers_full_v pkhr,
8228: okl_k_headers khr
8229: where pcn.pol_id = pol.id
8230: and pcn.khr_id = khr.id
8231: and pol.khr_id = pkhr.id

Line 8286: okl_K_headers_full_v pkhr,

8282: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8283: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8284: from okl_pools pol,
8285: okl_pool_contents pcn,
8286: okl_K_headers_full_v pkhr,
8287: okl_k_headers khr
8288: where pcn.pol_id = pol.id
8289: and pcn.khr_id = khr.id
8290: and pol.khr_id = pkhr.id

Line 8896: okl_K_headers_full_v pkhr,

8892: pkhr.contract_number agreement_number,
8893: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8894: from okl_pools pol,
8895: okl_pool_contents pcn,
8896: okl_K_headers_full_v pkhr,
8897: okl_k_headers khr
8898: where pcn.pol_id = pol.id
8899: and pcn.khr_id = khr.id
8900: and pol.khr_id = pkhr.id

Line 8957: okl_K_headers_full_v pkhr,

8953: pkhr.contract_number agreement_number,
8954: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8955: from okl_pools pol,
8956: okl_pool_contents pcn,
8957: okl_K_headers_full_v pkhr,
8958: okl_k_headers khr
8959: where pcn.pol_id = pol.id
8960: and pcn.khr_id = khr.id
8961: and pol.khr_id = pkhr.id