DBA Data[Home] [Help]

APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_K_LINES

Line 215: FROM okl_k_lines kleb_rv,

211: -- the revenue shares for the investor
212: CURSOR get_revenue_share_csr(p_inv_id NUMBER, p_stream_type_subclass VARCHAR2)
213: IS
214: SELECT kleb_rv.percent_stake percent_stake
215: FROM okl_k_lines kleb_rv,
216: okc_k_lines_b cles_rv,
217: okc_line_styles_b lseb_rv
218: WHERE
219: cles_rv.dnz_chr_id = p_inv_id

Line 1558: FROM OKL_K_LINES kleb

1554: -- the revenue shares for the investor
1555: CURSOR get_revenue_share_csr(p_tl_id NUMBER, p_stream_type_subclass VARCHAR2)
1556: IS
1557: SELECT kleb.percent_stake percent_stake
1558: FROM OKL_K_LINES kleb
1559: ,OKC_K_LINES_B cles
1560: ,OKC_LINE_STYLES_B lseb
1561: WHERE kleb.id = cles.id
1562: AND cles.cle_id = p_tl_id

Line 3247: FROM okl_k_lines_full_v kle,

3243: kle.initial_direct_cost,
3244: tl.item_description,
3245: tl.name,
3246: sts.ste_code
3247: FROM okl_k_lines_full_v kle,
3248: okc_line_styles_b lse,
3249: okc_k_lines_tl tl,
3250: okc_statuses_b sts
3251: WHERE kle.lse_id = lse.id

Line 3271: FROM okl_k_lines_full_v kle,

3267: tl.item_description,
3268: tl.name,
3269: sts.ste_code,
3270: lse.lty_code
3271: FROM okl_k_lines_full_v kle,
3272: okc_line_styles_b lse,
3273: okc_k_lines_tl tl,
3274: okc_statuses_b sts
3275: WHERE kle.lse_id = lse.id

Line 3293: okl_k_lines kle ,

3289: kle.capital_amount capital_amount,
3290: kle.amount amount,
3291: lse.lty_code lty_code
3292: FROM okc_k_lines_b okc,
3293: okl_k_lines kle ,
3294: okc_line_styles_b lse
3295: WHERE okc.cle_id = cleId
3296: AND okc.lse_id = lse.id
3297: AND okc.id = kle.id