DBA Data[Home] [Help]

APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_K_LINES

Line 213: FROM okl_k_lines kleb_rv,

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

Line 1093: FROM OKL_K_LINES kleb

1089: -- the revenue shares for the investor
1090: CURSOR get_revenue_share_csr(p_tl_id NUMBER, p_stream_type_subclass VARCHAR2)
1091: IS
1092: SELECT kleb.percent_stake percent_stake
1093: FROM OKL_K_LINES kleb
1094: ,OKC_K_LINES_B cles
1095: ,OKC_LINE_STYLES_B lseb
1096: WHERE kleb.id = cles.id
1097: AND cles.cle_id = p_tl_id

Line 2083: FROM okl_k_lines_full_v kle,

2079: kle.initial_direct_cost,
2080: tl.item_description,
2081: tl.name,
2082: sts.ste_code
2083: FROM okl_k_lines_full_v kle,
2084: okc_line_styles_b lse,
2085: okc_k_lines_tl tl,
2086: okc_statuses_b sts
2087: WHERE kle.lse_id = lse.id

Line 2107: FROM okl_k_lines_full_v kle,

2103: tl.item_description,
2104: tl.name,
2105: sts.ste_code,
2106: lse.lty_code
2107: FROM okl_k_lines_full_v kle,
2108: okc_line_styles_b lse,
2109: okc_k_lines_tl tl,
2110: okc_statuses_b sts
2111: WHERE kle.lse_id = lse.id

Line 2129: okl_k_lines kle ,

2125: kle.capital_amount capital_amount,
2126: kle.amount amount,
2127: lse.lty_code lty_code
2128: FROM okc_k_lines_b okc,
2129: okl_k_lines kle ,
2130: okc_line_styles_b lse
2131: WHERE okc.cle_id = cleId
2132: AND okc.lse_id = lse.id
2133: AND okc.id = kle.id