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 502: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr

498: o_end_date OUT NOCOPY DATE,
499: o_term_duration OUT NOCOPY NUMBER) IS
500: CURSOR contract_dates IS
501: SELECT khr.start_date,khr.end_date,okhr.term_duration
502: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr
503: WHERE okhr.id = khr.id
504: AND khr.id = p_contract_id;
505: BEGIN
506: OPEN contract_dates;

Line 1529: from OKL_K_HEADERS

1525: ,x_value OUT NOCOPY VARCHAR2
1526: ) IS
1527: cursor investor_assigned IS
1528: select SECURITIZED_CODE
1529: from OKL_K_HEADERS
1530: where id = p_contract_id;
1531: l_securitized VARCHAR2(1);
1532: BEGIN
1533: open investor_assigned;

Line 1899: FROM okl_k_headers okhr ,

1895: CURSOR c_get_terms_rem (p_contract_id IN NUMBER)
1896: IS
1897: 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))))
1898: payment_remaining
1899: FROM okl_k_headers okhr ,
1900: okc_k_headers_v khr
1901: WHERE okhr.id = khr.id
1902: AND khr.id = p_contract_id;
1903: