APPS.OKL_RELEASE_PVT dependencies on OKL_K_LINES

Line 2434: okl_k_lines kle,

2430: chrb.id new_chr_id,
2431: cleb.id new_cle_id
2432: From
2433: okc_k_lines_b cleb,
2434: okl_k_lines kle,
2435: okc_k_headers_b chrb
2436: where kle.id = cleb.id
2437: and cleb.dnz_chr_id = chrb.id
2438: and cleb.lse_id = 33 --financial asset line

Line 4098: okl_k_lines kle,

4094: cle.cle_id,
4095: sts.ste_code,
4096: cle.orig_system_id1
4097: FROM okc_k_lines_b cle,
4098: okl_k_lines kle,
4099: okc_line_styles_b lse,
4100: okc_statuses_b sts
4101: WHERE cle.dnz_chr_id = p_chr_id
4102: AND cle.chr_id = p_chr_id

Line 4151: okl_k_lines kle

4147: cle.cle_id,
4148: --avsingh
4149: cle.orig_system_id1
4150: FROM okc_k_lines_b cle,
4151: okl_k_lines kle
4152: WHERE cle.cle_id = p_cle_id
4153: AND cle.dnz_chr_id = p_chr_id
4154: AND cle.id = kle.id;
4155:

Line 4290: FROM okl_k_lines

4286:
4287: -- Start change for rollover by fmiao on 12-NOV-2004--
4288: CURSOR fee_type_csr (p_line_id NUMBER) IS
4289: SELECT fee_type
4290: FROM okl_k_lines
4291: WHERE id = p_line_id;
4292:
4293: l_fee_type okl_k_lines.fee_type%TYPE;
4294: -- End change for rollover by fmiao on 12-NOV-2004--

Line 4293: l_fee_type okl_k_lines.fee_type%TYPE;

4289: SELECT fee_type
4290: FROM okl_k_lines
4291: WHERE id = p_line_id;
4292:
4293: l_fee_type okl_k_lines.fee_type%TYPE;
4294: -- End change for rollover by fmiao on 12-NOV-2004--
4295:
4296: BEGIN
4297: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 5369: okl_k_lines kle,

5365: cle.cle_id,
5366: cle.orig_system_id1,
5367: sts.ste_code
5368: FROM okc_k_lines_b cle,
5369: okl_k_lines kle,
5370: okc_line_styles_b lse,
5371: okc_statuses_b sts
5372: WHERE cle.dnz_chr_id = p_chr_id
5373: AND cle.chr_id = p_chr_id

Line 5419: okl_k_lines kle

5415: cle.chr_id,
5416: cle.dnz_chr_id,
5417: cle.cle_id
5418: FROM okc_k_lines_b cle,
5419: okl_k_lines kle
5420: WHERE cle.cle_id = p_cle_id
5421: AND cle.dnz_chr_id = p_chr_id
5422: AND cle.id = kle.id;
5423:

Line 6054: okl_k_lines kle

6050: SELECT cle.id,
6051: kle.amount
6052: FROM okc_k_lines_b cle,
6053: okc_line_styles_b lse,
6054: okl_k_lines kle
6055: WHERE cle.chr_id = p_chr_id
6056: AND cle.dnz_chr_id = p_chr_id
6057: AND lse.lty_code IN ('FEE','SOLD_SERVICE')
6058: AND cle.lse_id = lse.id

Line 6066: okl_k_lines kle

6062: CURSOR subline_csr (p_chr_id IN NUMBER,
6063: p_cle_id IN NUMBER) IS
6064: SELECT SUM(NVL(kle.capital_amount,kle.amount)) sum_amount
6065: FROM okc_k_lines_b cle,
6066: okl_k_lines kle
6067: WHERE cle.cle_id = p_cle_id
6068: AND cle.dnz_chr_id = p_chr_id
6069: AND kle.id = cle.id;
6070: