DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKC_STATUSES_V

Line 228: okc_statuses_v okcsts

224: CURSOR non_linked_usage_csr (p_chr_id NUMBER) IS
225: SELECT cle.id usage_line_id
226: FROM okc_line_styles_b lse,
227: okc_k_lines_b cle,
228: okc_statuses_v okcsts
229: WHERE cle.dnz_chr_id = p_chr_id
230: AND cle.lse_id = lse.id
231: AND lse.lse_parent_id is null
232: AND lse.lty_code ='USAGE'

Line 252: okc_k_lines_b cle,okc_statuses_v okcsts

248:
249: CURSOR usage_csr (p_chr_id NUMBER) IS
250: SELECT cle.id usage_line_id
251: FROM okc_line_styles_b lse,
252: okc_k_lines_b cle,okc_statuses_v okcsts
253: WHERE cle.dnz_chr_id = p_chr_id
254: AND cle.lse_id = lse.id
255: AND lse.lse_parent_id is null
256: AND lse.lty_code ='USAGE'