DBA Data[Home] [Help]

APPS.OKL_PAYMENT_SPLIT_PVT dependencies on OKC_LINE_STYLES_V

Line 359: FROM okc_line_styles_v style

355: SELECT SUM(NVL(line.capital_amount,0))
356: FROM okl_k_lines_full_v line
357: WHERE line.dnz_chr_id = p_chr_id
358: AND EXISTS ( SELECT 'Y'
359: FROM okc_line_styles_v style
360: WHERE line.lse_id = style.id
361: AND style.lty_code = 'FREE_FORM1'
362: )
363: -- added to handle abandon line

Line 374: okc_line_styles_v style,

370: -- Total Capital amount from FEE Top Line
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