APPS.OKL_PAYMENT_SPLIT_PVT dependencies on OKL_STRMTYP_SOURCE_V

Line 86: okl_strmtyp_source_v stream

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'
90: AND okl1.id = item1.cle_id

Line 213: FROM okl_strmtyp_source_v

209: l_proc_name VARCHAR2(35) := 'GEN_LINE_RULE';
210:
211: CURSOR strm_csr (p_strm_code VARCHAR2) IS
212: SELECT ID1
213: FROM okl_strmtyp_source_v
214: WHERE code = p_strm_code;
215:
216: -- _new indicates the rules that got created under Line as part of payment applications
217: x_new_rgpv_rec rgpv_rec_type;

Line 376: okl_strmtyp_source_v stream

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'
380: AND line.lse_id = style.id

Line 493: FROM okl_strmtyp_source_v

489: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
490:
491: CURSOR payment_csr (p_strm_code VARCHAR2) IS
492: SELECT 'Y'
493: FROM okl_strmtyp_source_v
494: WHERE code = p_strm_code;
495:
496: CURSOR freq_csr (p_freq_code VARCHAR2) IS
497: SELECT 'Y'