DBA Data[Home] [Help]

APPS.OKL_PAYMENT_SPLIT_PVT dependencies on OKC_K_ITEMS_V

Line 84: okc_k_items_v item1,

80: CURSOR cap_csr (p_fin_line_id NUMBER) IS
81: SELECT SUM(NVL(okl1.capital_amount,0))
82: FROM okl_k_lines_full_v okl1, -- fee sub line
83: okl_k_lines_full_v okl2, -- fee top line
84: okc_k_items_v item1,
85: okc_k_items_v item2,
86: okl_strmtyp_source_v stream
87: WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454
88: AND item1.jtot_object1_code = 'OKX_COVASST' -- Bug 3830454

Line 85: okc_k_items_v item2,

81: SELECT SUM(NVL(okl1.capital_amount,0))
82: FROM okl_k_lines_full_v okl1, -- fee sub line
83: okl_k_lines_full_v okl2, -- fee top line
84: okc_k_items_v item1,
85: okc_k_items_v item2,
86: okl_strmtyp_source_v stream
87: WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454
88: AND item1.jtot_object1_code = 'OKX_COVASST' -- Bug 3830454
89: AND stream.capitalize_yn = 'Y'

Line 375: okc_k_items_v item,

371: CURSOR fee_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
372: SELECT SUM(NVL(line.capital_amount,0))
373: FROM okl_k_lines_full_v line,
374: okc_line_styles_v style,
375: okc_k_items_v item,
376: okl_strmtyp_source_v stream
377: WHERE style.lty_code = 'FEE'
378: AND line.dnz_chr_id = p_chr_id
379: AND stream.capitalize_yn = 'Y'