DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 10682: okl_K_headers_full_v pkhr,

10678: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
10679: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10680: from okl_pools pol,
10681: okl_pool_contents pcn,
10682: okl_K_headers_full_v pkhr,
10683: okl_k_headers khr
10684: where pcn.pol_id = pol.id
10685: and pcn.khr_id = khr.id
10686: and pol.khr_id = pkhr.id

Line 10741: okl_K_headers_full_v pkhr,

10737: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
10738: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10739: from okl_pools pol,
10740: okl_pool_contents pcn,
10741: okl_K_headers_full_v pkhr,
10742: okl_k_headers khr
10743: where pcn.pol_id = pol.id
10744: and pcn.khr_id = khr.id
10745: and pol.khr_id = pkhr.id

Line 11351: okl_K_headers_full_v pkhr,

11347: pkhr.contract_number agreement_number,
11348: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11349: from okl_pools pol,
11350: okl_pool_contents pcn,
11351: okl_K_headers_full_v pkhr,
11352: okl_k_headers khr
11353: where pcn.pol_id = pol.id
11354: and pcn.khr_id = khr.id
11355: and pol.khr_id = pkhr.id

Line 11412: okl_K_headers_full_v pkhr,

11408: pkhr.contract_number agreement_number,
11409: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11410: from okl_pools pol,
11411: okl_pool_contents pcn,
11412: okl_K_headers_full_v pkhr,
11413: okl_k_headers khr
11414: where pcn.pol_id = pol.id
11415: and pcn.khr_id = khr.id
11416: and pol.khr_id = pkhr.id