DBA Data[Home] [Help]

APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_K_LINES

Line 6567: okl_k_lines kle

6563: FROM okc_k_headers_b CHR
6564: WHERE EXISTS (SELECT 1
6565: FROM okc_line_styles_b lse,
6566: okc_k_lines_b cle,
6567: okl_k_lines kle
6568: WHERE cle.dnz_chr_id = CHR.id
6569: AND cle.lse_id = lse.id
6570: AND cle.id = kle.id
6571: -- START: cklee/mvasudev,10/14/2005,bug#4300891 - (okl.g Bug#4307723)

Line 6596: okl_k_lines kle

6592: CURSOR get_fin_ast_csr IS
6593: SELECT cle.id
6594: FROM okc_line_styles_b lse,
6595: okc_k_lines_b cle,
6596: okl_k_lines kle
6597: WHERE cle.dnz_chr_id = p_durv_rec.chr_id
6598: AND cle.lse_id = lse.id
6599: AND cle.id = kle.id
6600: AND lse.lty_code = 'FREE_FORM1';

Line 7437: -- the the re_lease_yn flag on okl_k_lines

7433:
7434: --Bug# 15992711: Comment the validation at contract header level
7435: -- on the re-leased asset flag.
7436: -- whether an asset is a release or new asset is determined by
7437: -- the the re_lease_yn flag on okl_k_lines
7438: /* IF( (l_fin_ast = 'Y') AND (NOT(p_durv_rec.r_larles_rule_information1 = l_lrls_yn))) THEN
7439:
7440: x_return_status := OKC_API.g_ret_sts_error;
7441: OKC_API.SET_MESSAGE( p_app_name => g_app_name