DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_STRM_TYPE_B

Line 5438: FROM okl_strm_type_b styb,

5434: -- cursor to get stream name and stream id
5435:
5436: CURSOR get_stream_name_csr (p_chr_id in NUMBER) IS
5437: SELECT styb.id, styb.code
5438: FROM okl_strm_type_b styb,
5439: okc_k_items cim,
5440: okc_k_lines_b cleb,
5441: okl_k_lines kle
5442: WHERE styb.id = cim.object1_id1

Line 5468: l_strm_id okl_strm_type_b.id%type;

5464: l_fee_types_rec fee_types_rec_type := p_fee_types_rec;
5465: l_line_id okc_k_lines_b.id%type;
5466: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5467: l_check_box_value VARCHAR2(450);
5468: l_strm_id okl_strm_type_b.id%type;
5469: l_strm_name okl_strm_type_b.code%type;
5470: l_fee_line_id okl_k_lines.id%type;
5471: l_amount okl_k_lines.amount%type;
5472:

Line 5469: l_strm_name okl_strm_type_b.code%type;

5465: l_line_id okc_k_lines_b.id%type;
5466: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5467: l_check_box_value VARCHAR2(450);
5468: l_strm_id okl_strm_type_b.id%type;
5469: l_strm_name okl_strm_type_b.code%type;
5470: l_fee_line_id okl_k_lines.id%type;
5471: l_amount okl_k_lines.amount%type;
5472:
5473: l_start_date DATE;