DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_K_ITEMS_V

Line 259: okc_k_items_v item1,

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

Line 260: okc_k_items_v item2,

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