APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKC_K_LINES_B

Line 575: OKC_K_LINES_B LINES,

571: FA_BOOKS.cost ASSET_COST,
572: FA_BOOKS.book_type_code BOOK_TYPE_CODE
573: from FA_BOOKS ,
574: FA_BOOK_CONTROLS,
575: OKC_K_LINES_B LINES,
576: OKC_LINE_STYLES_B STYLE,
577: OKC_K_ITEMS KITEM
578: where FA_BOOKS.asset_id = KITEM.OBJECT1_ID1
579: and LINES.DNZ_CHR_ID = p_chr_id --291511068054787299132375269533568315520

Line 1565: CURSOR check_asset_term_csr(p_kle_id OKC_K_LINES_B.ID%TYPE) IS

1561: AND SRLB.LEVEL_INDEX_NUMBER = 0
1562: AND SILB.KLE_ID = p_kle_id;
1563:
1564: --Added by bkatraga for bug 14811647
1565: CURSOR check_asset_term_csr(p_kle_id OKC_K_LINES_B.ID%TYPE) IS
1566: SELECT 'Y'
1567: FROM OKC_K_LINES_B CLE
1568: , OKC_STATUSES_B STS
1569: WHERE CLE.ID = p_kle_id

Line 1567: FROM OKC_K_LINES_B CLE

1563:
1564: --Added by bkatraga for bug 14811647
1565: CURSOR check_asset_term_csr(p_kle_id OKC_K_LINES_B.ID%TYPE) IS
1566: SELECT 'Y'
1567: FROM OKC_K_LINES_B CLE
1568: , OKC_STATUSES_B STS
1569: WHERE CLE.ID = p_kle_id
1570: AND CLE.LSE_ID = 33
1571: AND STS.CODE = CLE.STS_CODE

Line 1651: FROM okc_k_lines_b

1647: --Added TERMINATED status by bkatraga for bug 14811647
1648: --Bug# 14559654
1649: CURSOR c_get_asset_lines(p_contract_id IN NUMBER) IS
1650: SELECT id
1651: FROM okc_k_lines_b
1652: WHERE chr_id = p_contract_id
1653: AND dnz_chr_id = p_contract_id
1654: AND lse_id = 33
1655: AND sts_code NOT IN('ABANDONED', 'TERMINATED');