APPS.OKL_SEC_INVESTOR_REVENUE_PVT dependencies on OKL_K_LINES

Line 14: FROM okl_k_lines kleb,

10: /*
11: CURSOR l_okl_sty_percent_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER)
12: IS
13: SELECT kleb.percent_stake percent_stake
14: FROM okl_k_lines kleb,
15: okc_k_lines_b cles
16: WHERE kleb.id = cles.id
17: AND cles.dnz_chr_id = p_khr_id
18: AND cles.cle_id IS NOT NULL

Line 25: FROM okl_k_lines kleb,

21: */
22: CURSOR l_okl_sty_percent_csr(p_khr_id IN NUMBER, p_sty_subclass IN VARCHAR2)
23: IS
24: SELECT kleb.percent_stake percent_stake
25: FROM okl_k_lines kleb,
26: okc_k_lines_b cles
27: WHERE kleb.id = cles.id
28: AND cles.dnz_chr_id = p_khr_id
29: AND cles.cle_id IS NOT NULL

Line 37: FROM okl_k_lines kleb,

33: -- To check only one row exists for a subclass for an Investor
34: CURSOR l_okl_sty_subclass_csr(p_khr_id IN NUMBER, p_top_line_id IN NUMBER,p_sty_subclass IN VARCHAR2)
35: IS
36: SELECT '1'
37: FROM okl_k_lines kleb,
38: okc_k_lines_b cles
39: WHERE kleb.id = cles.id
40: AND cles.dnz_chr_id = p_khr_id
41: AND cles.cle_id = p_top_line_id

Line 210: OKL_K_LINES KLEB,

206: /*
207: CURSOR l_okl_cle_sty_csr(p_cle_id IN NUMBER, p_sty_id IN NUMBER) IS
208: SELECT '1'
209: FROM
210: OKL_K_LINES KLEB,
211: OKC_K_LINES_B CLET,
212: OKC_K_LINES_B CLES
213: WHERE
214: KLEB.ID = CLES.ID

Line 222: OKL_K_LINES KLEB,

218: */
219: CURSOR l_okl_cle_sty_csr(p_cle_id IN NUMBER, p_sty_subclass IN VARCHAR2) IS
220: SELECT '1'
221: FROM
222: OKL_K_LINES KLEB,
223: OKC_K_LINES_B CLET,
224: OKC_K_LINES_B CLES
225: WHERE
226: KLEB.ID = CLES.ID

Line 236: OKL_K_LINES KLEB,

232: /* Taken care in migrate function
233: CURSOR l_okl_cle_start_date_csr(p_cle_id IN NUMBER) IS
234: SELECT CLET.START_DATE
235: FROM
236: OKL_K_LINES KLEB,
237: OKC_K_LINES_B CLET,
238: OKC_K_LINES_B CLES
239: WHERE
240: KLEB.ID = CLES.ID