APPS.OKS_RENCPY_PVT dependencies on OKC_K_LINES_B

Line 647: FROM okc_k_lines_b

643: l_new_rul_id NUMBER := OKC_API.G_MISS_NUM;
644:
645: CURSOR c_dnz_chr_id(p_id IN NUMBER) IS
646: SELECT dnz_chr_id
647: FROM okc_k_lines_b
648: WHERE id = p_id;
649:
650: CURSOR c_atn(p_id IN NUMBER) IS
651: SELECT id

Line 841: FROM okc_k_lines_b

837: l_cle_id NUMBER := OKC_API.G_MISS_NUM;
838:
839: CURSOR c_dnz_chr_id(p_id IN NUMBER) IS
840: SELECT dnz_chr_id
841: FROM okc_k_lines_b
842: WHERE id = p_id;
843:
844: CURSOR c_ctcv IS
845: SELECT id

Line 965: FROM okc_k_lines_b

961: l_trx_ext_id NUMBER;
962:
963: CURSOR c_dnz_chr_id(p_id IN NUMBER) IS
964: SELECT dnz_chr_id
965: FROM okc_k_lines_b
966: WHERE id = p_id;
967:
968: -- bug 5139719
969: CURSOR cur_hdr_uom IS

Line 1127: FROM okc_k_lines_b

1123: l_item_desc VARCHAR2(2000);
1124:
1125: CURSOR c_dnz_chr_id IS
1126: SELECT dnz_chr_id, price_level_ind
1127: FROM okc_k_lines_b
1128: WHERE id = p_to_cle_id;
1129:
1130: CURSOR c_cimv IS
1131: SELECT id

Line 1344: FROM okc_k_lines_b

1340:
1341:
1342: CURSOR c_dnz_chr_id IS
1343: SELECT dnz_chr_id
1344: FROM okc_k_lines_b
1345: WHERE id = p_to_cle_id;
1346:
1347: CURSOR c_pavv IS
1348: SELECT id

Line 1705: FROM okc_k_lines_b

1701: l_parent_end_date DATE;
1702:
1703: CURSOR c_cle IS
1704: SELECT start_date, end_date
1705: FROM okc_k_lines_b
1706: WHERE id = p_to_cle_id;
1707:
1708: CURSOR c_chr IS
1709: SELECT start_date, end_date

Line 1756: FROM okc_k_lines_b

1752: CURSOR header_cur(p_cle_id IN NUMBER) IS
1753: SELECT id, currency_code
1754: FROM okc_k_headers_b
1755: WHERE id = (SELECT dnz_chr_id
1756: FROM okc_k_lines_b
1757: WHERE id = p_cle_id);
1758:
1759: l_hdr_id NUMBER;
1760: l_curr_code VARCHAR2(15);

Line 1948: FROM okc_k_lines_b

1944:
1945: DECLARE -- Added by Jacob K. on 09/07/01 for the line numbering functionality
1946: CURSOR c_toplinenum(p_id IN NUMBER) IS
1947: SELECT MAX(to_number(line_number))
1948: FROM okc_k_lines_b
1949: WHERE dnz_chr_id = p_id
1950: AND cle_id IS NULL;
1951: CURSOR c_sublinenum(p_id IN NUMBER) IS
1952: SELECT MAX(to_number(line_number))

Line 1953: FROM okc_k_lines_b

1949: WHERE dnz_chr_id = p_id
1950: AND cle_id IS NULL;
1951: CURSOR c_sublinenum(p_id IN NUMBER) IS
1952: SELECT MAX(to_number(line_number))
1953: FROM okc_k_lines_b
1954: WHERE cle_id = p_id
1955: AND lse_id IN (7, 8, 9, 10, 11, 35, 25);
1956: BEGIN
1957: IF l_clev_rec.lse_id IN (1, 12, 14, 19) THEN