APPS.OKL_VR_DOCUMENT_PVT dependencies on OKC_K_HEADERS_B

Line 36: FROM okc_k_headers_b a, okl_k_headers b

32:
33: -- Get the financial product of the contract
34: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
35: SELECT a.start_date, a.contract_number, b.pdt_id
36: FROM okc_k_headers_b a, okl_k_headers b
37: WHERE a.id = b.id
38: AND a.id = cp_khr_id;
39:
40: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 268: FROM OKC_K_HEADERS_B

264:
265: --Added by dpsingh for LE Uptake
266: CURSOR get_contract_number(p_khr_id NUMBER) IS
267: SELECT CONTRACT_NUMBER
268: FROM OKC_K_HEADERS_B
269: WHERE ID = p_khr_id ;
270:
271: --Added by dpsingh for LE Uptake
272: -- Bug 5964482 dpsingh for AE signature Uptake start

Line 313: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

309:
310:
311: -- Bug 5964482 dpsingh for AE signature Uptake end
312: l_legal_entity_id NUMBER;
313: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
314: l_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
315: lx_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
316: l_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
317: lx_rep_selv_rec Okl_Streams_Pub.selv_rec_type;