APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_K_HEADERS

Line 34: FROM okl_k_headers_v khr ,fnd_lookups fnd

30: ,x_value OUT NOCOPY NUMBER
31: ) IS
32: CURSOR deal_type IS
33: SELECT khr.deal_type
34: FROM okl_k_headers_v khr ,fnd_lookups fnd
35: WHERE fnd.lookup_type = 'OKL_BOOK_CLASS'
36: AND fnd.lookup_code = khr.deal_type
37: AND id = p_contract_id;
38:

Line 43: okl_k_headers khr

39: --bug# 5032491 rkuttiya added cursor for revenue recognition
40: CURSOR c_revenue_recogn(p_khr_id IN NUMBER) IS
41: SELECT revenue_recognition_method
42: FROM okl_product_parameters_v pdt,
43: okl_k_headers khr
44: WHERE KHR.ID = p_khr_id
45: AND KHR.PDT_ID = PDT.ID;
46:
47: l_deal_type VARCHAR2(30);

Line 215: FROM okl_k_headers

211: --Added the following cursor for bug fix 2993308
212:
213: CURSOR deal_type IS
214: SELECT deal_type
215: FROM okl_k_headers
216: WHERE id = p_contract_id;
217:
218: l_deal_type VARCHAR2(30);
219: l_stream_name VARCHAR2(30);

Line 540: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr

536: o_end_date OUT NOCOPY DATE,
537: o_term_duration OUT NOCOPY NUMBER) IS
538: CURSOR contract_dates IS
539: SELECT khr.start_date,khr.end_date,okhr.term_duration
540: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr
541: WHERE okhr.id = khr.id
542: AND khr.id = p_contract_id;
543: BEGIN
544: OPEN contract_dates;

Line 1567: from OKL_K_HEADERS

1563: ,x_value OUT NOCOPY VARCHAR2
1564: ) IS
1565: cursor investor_assigned IS
1566: select SECURITIZED_CODE
1567: from OKL_K_HEADERS
1568: where id = p_contract_id;
1569: l_securitized VARCHAR2(1);
1570: BEGIN
1571: open investor_assigned;

Line 1937: FROM okl_k_headers okhr ,

1933: CURSOR c_get_terms_rem (p_contract_id IN NUMBER)
1934: IS
1935: SELECT okhr.term_duration-DECODE(sign(sysdate-khr.start_date),-1,0,DECODE(sign(sysdate-khr.end_date),1,okhr.term_duration,TRUNC(MONTHS_BETWEEN(sysdate,khr.start_date))))
1936: payment_remaining
1937: FROM okl_k_headers okhr ,
1938: okc_k_headers_v khr
1939: WHERE okhr.id = khr.id
1940: AND khr.id = p_contract_id;
1941: