DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_K_ITEMS_V

Line 263: okc_k_items_v item1,

259: CURSOR cap_csr (p_fin_line_id NUMBER) IS
260: SELECT SUM(NVL(okl1.capital_amount,0))
261: FROM okl_k_lines_full_v okl1, -- fee sub line
262: okl_k_lines_full_v okl2, -- fee top line
263: okc_k_items_v item1,
264: okc_k_items_v item2,
265: okl_strmtyp_source_v stream
266: WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454
267: AND item1.jtot_object1_code = 'OKX_COVASST' -- Bug 3830454

Line 264: okc_k_items_v item2,

260: SELECT SUM(NVL(okl1.capital_amount,0))
261: FROM okl_k_lines_full_v okl1, -- fee sub line
262: okl_k_lines_full_v okl2, -- fee top line
263: okc_k_items_v item1,
264: okc_k_items_v item2,
265: okl_strmtyp_source_v stream
266: WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454
267: AND item1.jtot_object1_code = 'OKX_COVASST' -- Bug 3830454
268: AND stream.capitalize_yn = 'Y'