APPS.OKL_RELEASE_PVT dependencies on OKL_K_LINES

Line 2458: okl_k_lines kle,

2454: chrb.id new_chr_id,
2455: cleb.id new_cle_id
2456: From
2457: okc_k_lines_b cleb,
2458: okl_k_lines kle,
2459: okc_k_headers_b chrb
2460: where kle.id = cleb.id
2461: and cleb.dnz_chr_id = chrb.id
2462: and cleb.lse_id = 33 --financial asset line

Line 4158: okl_k_lines kle,

4154: cle.cle_id,
4155: sts.ste_code,
4156: cle.orig_system_id1
4157: FROM okc_k_lines_b cle,
4158: okl_k_lines kle,
4159: okc_line_styles_b lse,
4160: okc_statuses_b sts
4161: WHERE cle.dnz_chr_id = p_chr_id
4162: AND cle.chr_id = p_chr_id

Line 4211: okl_k_lines kle

4207: cle.cle_id,
4208: --avsingh
4209: cle.orig_system_id1
4210: FROM okc_k_lines_b cle,
4211: okl_k_lines kle
4212: WHERE cle.cle_id = p_cle_id
4213: AND cle.dnz_chr_id = p_chr_id
4214: AND cle.id = kle.id;
4215:

Line 4350: FROM okl_k_lines

4346:
4347: -- Start change for rollover by fmiao on 12-NOV-2004--
4348: CURSOR fee_type_csr (p_line_id NUMBER) IS
4349: SELECT fee_type
4350: FROM okl_k_lines
4351: WHERE id = p_line_id;
4352:
4353: l_fee_type okl_k_lines.fee_type%TYPE;
4354: -- End change for rollover by fmiao on 12-NOV-2004--

Line 4353: l_fee_type okl_k_lines.fee_type%TYPE;

4349: SELECT fee_type
4350: FROM okl_k_lines
4351: WHERE id = p_line_id;
4352:
4353: l_fee_type okl_k_lines.fee_type%TYPE;
4354: -- End change for rollover by fmiao on 12-NOV-2004--
4355:
4356: --Bug# 9927005
4357: l_fin_sub_total NUMBER;

Line 5678: okl_k_lines kle,

5674: cle.cle_id,
5675: cle.orig_system_id1,
5676: sts.ste_code
5677: FROM okc_k_lines_b cle,
5678: okl_k_lines kle,
5679: okc_line_styles_b lse,
5680: okc_statuses_b sts
5681: WHERE cle.dnz_chr_id = p_chr_id
5682: AND cle.chr_id = p_chr_id

Line 5728: okl_k_lines kle

5724: cle.chr_id,
5725: cle.dnz_chr_id,
5726: cle.cle_id
5727: FROM okc_k_lines_b cle,
5728: okl_k_lines kle
5729: WHERE cle.cle_id = p_cle_id
5730: AND cle.dnz_chr_id = p_chr_id
5731: AND cle.id = kle.id;
5732:

Line 6363: okl_k_lines kle

6359: SELECT cle.id,
6360: kle.amount
6361: FROM okc_k_lines_b cle,
6362: okc_line_styles_b lse,
6363: okl_k_lines kle
6364: WHERE cle.chr_id = p_chr_id
6365: AND cle.dnz_chr_id = p_chr_id
6366: AND lse.lty_code IN ('FEE','SOLD_SERVICE')
6367: AND cle.lse_id = lse.id

Line 6375: okl_k_lines kle

6371: CURSOR subline_csr (p_chr_id IN NUMBER,
6372: p_cle_id IN NUMBER) IS
6373: SELECT SUM(NVL(kle.capital_amount,kle.amount)) sum_amount
6374: FROM okc_k_lines_b cle,
6375: okl_k_lines kle
6376: WHERE cle.cle_id = p_cle_id
6377: AND cle.dnz_chr_id = p_chr_id
6378: AND kle.id = cle.id;
6379: