APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKC_K_LINES_B

Line 612: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

608: okc_k_headers_b chr
609: WHERE
610: EXISTS ( SELECT 'x' FROM okc_k_items cim
611: WHERE cim.object1_id1 = to_char(chr.id) AND
612: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
613: WHERE cle.lse_id = lse.id AND
614: lse.lty_code = 'SHARED' AND cle.id = cim.cle_id ) AND
615: EXISTS ( SELECT 'x' FROM okc_k_headers_b chr2
616: WHERE chr2.id = cim.dnz_chr_id AND

Line 1012: FROM okc_k_lines_b

1008: and sele.DATE_BILLED is null;
1009: CURSOR c_get_parent_kle_id(c_kle_id NUMBER)
1010: IS
1011: SELECT orig_system_id1
1012: FROM okc_k_lines_b
1013: where id=c_kle_id;
1014:
1015: BEGIN
1016: --Since Streams are not generated for the Copied Contract, We have to

Line 1239: FROM okc_k_lines_b cle, okc_line_styles_b lse

1235: -- Get all the assets attached to the contract
1236: -- These lines may or may not have payments associated with them
1237: CURSOR l_okcklines_csr(cp_chr_id IN NUMBER) IS
1238: SELECT cle.id, cle.lse_id, lse.lty_code
1239: FROM okc_k_lines_b cle, okc_line_styles_b lse
1240: WHERE cle.lse_id = lse.id
1241: AND cle.sts_code = 'BOOKED'
1242: AND lse.lty_code = 'FREE_FORM1'
1243: AND chr_id = cp_chr_id;

Line 2505: FROM okc_k_lines_b cle, okc_line_styles_b lse

2501: ORDER BY start_date;
2502:
2503: CURSOR l_okcklines_csr(cp_chr_id IN NUMBER) IS
2504: SELECT cle.id kle_id
2505: FROM okc_k_lines_b cle, okc_line_styles_b lse
2506: WHERE cle.lse_id = lse.id
2507: AND cle.sts_code = 'BOOKED'
2508: AND lse.lty_code = 'FREE_FORM1'
2509: AND chr_id = cp_chr_id;