APPS.OKS_RENCPY_PVT dependencies on OKC_K_HEADERS_B

Line 1246: FROM okc_k_headers_b

1242: PROCEDURE Set_Attach_Session_Vars(p_chr_id NUMBER) IS
1243: l_app_id NUMBER;
1244: CURSOR l_chr_csr IS
1245: SELECT application_id
1246: FROM okc_k_headers_b
1247: WHERE id = p_chr_id;
1248: BEGIN
1249: IF (p_chr_id IS NOT NULL AND
1250: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

Line 1710: FROM okc_k_headers_b

1706: WHERE id = p_to_cle_id;
1707:
1708: CURSOR c_chr IS
1709: SELECT start_date, end_date
1710: FROM okc_k_headers_b
1711: WHERE id = p_to_chr_id;
1712:
1713: BEGIN
1714:

Line 1754: FROM okc_k_headers_b

1750: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
1751:
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:

Line 1779: FROM okc_k_headers_b

1775: x_return_status OUT NOCOPY VARCHAR2) IS
1776:
1777: CURSOR cvn_cur IS
1778: SELECT CONVERSION_TYPE, CONVERSION_RATE, CONVERSION_RATE_DATE
1779: FROM okc_k_headers_b
1780: WHERE id = p_chr_id;
1781: /*
1782: cursor cvn_type_cur(p_id in varchar2) is
1783: select name