DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_STRM_TYPE_B

Line 5451: FROM okl_strm_type_b styb,

5447: -- cursor to get stream name and stream id
5448:
5449: CURSOR get_stream_name_csr (p_chr_id in NUMBER) IS
5450: SELECT styb.id, styb.code
5451: FROM okl_strm_type_b styb,
5452: okc_k_items cim,
5453: okc_k_lines_b cleb,
5454: okl_k_lines kle
5455: WHERE styb.id = cim.object1_id1

Line 5481: l_strm_id okl_strm_type_b.id%type;

5477: l_fee_types_rec fee_types_rec_type := p_fee_types_rec;
5478: l_line_id okc_k_lines_b.id%type;
5479: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5480: l_check_box_value VARCHAR2(450);
5481: l_strm_id okl_strm_type_b.id%type;
5482: l_strm_name okl_strm_type_b.code%type;
5483: l_fee_line_id okl_k_lines.id%type;
5484: l_amount okl_k_lines.amount%type;
5485:

Line 5482: l_strm_name okl_strm_type_b.code%type;

5478: l_line_id okc_k_lines_b.id%type;
5479: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5480: l_check_box_value VARCHAR2(450);
5481: l_strm_id okl_strm_type_b.id%type;
5482: l_strm_name okl_strm_type_b.code%type;
5483: l_fee_line_id okl_k_lines.id%type;
5484: l_amount okl_k_lines.amount%type;
5485:
5486: l_start_date DATE;