APPS.OKL_SEC_INVESTOR_REVENUE_PVT dependencies on OKC_K_LINES_B

Line 15: okc_k_lines_b cles

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
19: AND kleb.sty_id = p_sty_id

Line 26: okc_k_lines_b cles

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
30: AND kleb.stream_type_subclass = p_sty_subclass

Line 38: okc_k_lines_b cles

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
42: AND kleb.stream_type_subclass = p_sty_subclass

Line 157: FROM okc_k_lines_b clet

153: IS
154: SELECT clet.start_date
155: ,clet.end_date
156: ,clet.currency_code
157: FROM okc_k_lines_b clet
158: ,okc_line_styles_b lseb
159: WHERE clet.id = p_tl_id
160: AND clet.lse_id = lseb.id
161: AND lseb.lty_code = 'INVESTMENT';

Line 211: OKC_K_LINES_B CLET,

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
215: AND CLES.CLE_ID = CLET.ID

Line 212: OKC_K_LINES_B CLES

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
215: AND CLES.CLE_ID = CLET.ID
216: AND CLET.ID = p_cle_id

Line 223: OKC_K_LINES_B CLET,

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
227: AND CLES.CLE_ID = CLET.ID

Line 224: OKC_K_LINES_B CLES

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
227: AND CLES.CLE_ID = CLET.ID
228: AND CLET.ID = p_cle_id

Line 237: OKC_K_LINES_B CLET,

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
241: AND CLES.CLE_ID = CLET.ID

Line 238: OKC_K_LINES_B CLES

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
241: AND CLES.CLE_ID = CLET.ID
242: AND CLET.ID = p_cle_id;