APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKL_K_LINES_FULL_V

Line 303: from okl_k_lines_full_v sub_line, okc_k_items_v link_ast

299: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
300:
301: CURSOR get_item_csr(p_chr_id NUMBER, p_parent_cle_id NUMBER, p_link_ast_id1 VARCHAR2, p_link_ast_id2 VARCHAR2) IS
302: SELECT link_ast.id
303: from okl_k_lines_full_v sub_line, okc_k_items_v link_ast
304: where sub_line.id = link_ast.cle_id
305: and link_ast.object1_id1 = p_link_ast_id1
306: and link_ast.object1_id2 = p_link_ast_id2
307: and sub_line.cle_id = p_parent_cle_id

Line 1145: from okl_k_lines_full_v cle

1141: and cle.dnz_chr_id = p_chr_id;
1142:
1143: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
1144: select cle.fee_type
1145: from okl_k_lines_full_v cle
1146: where cle.id = p_cle_id
1147: and cle.dnz_chr_id = p_chr_id;
1148:
1149: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

Line 1583: l_fee_type okl_k_lines_full_v.fee_type%type := null;

1579: i NUMBER;
1580: l_chr_id NUMBER;
1581: l_parent_cle_id NUMBER;
1582: l_cnt number := 0;
1583: l_fee_type okl_k_lines_full_v.fee_type%type := null;
1584: l_amount number := null;
1585:
1586: l_currency_code okl_k_headers_full_v.currency_code%type := null;
1587: l_sts_code okl_k_headers_full_v.sts_code%type := null;

Line 1663: from okl_k_lines_full_v cle

1659: --Bug# 3877032
1660:
1661: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
1662: select cle.fee_type
1663: from okl_k_lines_full_v cle
1664: where cle.id = p_cle_id
1665: and cle.dnz_chr_id = p_chr_id;
1666:
1667: BEGIN

Line 2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;

2158:
2159: l_start_date okc_k_lines_b.start_date%type := null;
2160: l_end_date okc_k_lines_b.end_date%type := null;
2161: l_amount number;
2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;
2163:
2164: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2165: select cle.fee_type
2166: from okl_k_lines_full_v cle

Line 2166: from okl_k_lines_full_v cle

2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;
2163:
2164: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2165: select cle.fee_type
2166: from okl_k_lines_full_v cle
2167: where cle.id = p_cle_id
2168: and cle.dnz_chr_id = p_chr_id;
2169:
2170: BEGIN

Line 2521: from okl_k_lines_full_v cle

2517: l_end_date okc_k_lines_b.end_date%type := null;
2518:
2519: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2520: select cle.fee_type
2521: from okl_k_lines_full_v cle
2522: where cle.id = p_cle_id
2523: and cle.dnz_chr_id = p_chr_id;
2524:
2525: -- Bug# 6598350