APPS.OKL_INS_CLAIM_ASSET_PVT dependencies on OKC_K_LINES_B

Line 36: FROM OKC_K_LINES_B A,

32: l_api_version CONSTANT NUMBER := 1;
33:
34: CURSOR l_acdv_csr(p_kle_id NUMBER) IS
35: SELECT CSI.LOCATION_ID
36: FROM OKC_K_LINES_B A,
37: OKC_K_LINES_B B,
38: OKC_K_LINES_B C,
39: OKC_K_ITEMS CIM,
40: OKX_INSTALL_ITEMS_V CSI

Line 37: OKC_K_LINES_B B,

33:
34: CURSOR l_acdv_csr(p_kle_id NUMBER) IS
35: SELECT CSI.LOCATION_ID
36: FROM OKC_K_LINES_B A,
37: OKC_K_LINES_B B,
38: OKC_K_LINES_B C,
39: OKC_K_ITEMS CIM,
40: OKX_INSTALL_ITEMS_V CSI
41: WHERE A.ID = p_kle_id

Line 38: OKC_K_LINES_B C,

34: CURSOR l_acdv_csr(p_kle_id NUMBER) IS
35: SELECT CSI.LOCATION_ID
36: FROM OKC_K_LINES_B A,
37: OKC_K_LINES_B B,
38: OKC_K_LINES_B C,
39: OKC_K_ITEMS CIM,
40: OKX_INSTALL_ITEMS_V CSI
41: WHERE A.ID = p_kle_id
42: AND B.CLE_ID = A.ID

Line 53: from okc_k_lines_b cle , okc_line_styles_b lse

49: AND CSI.ID2 = CIM.OBJECT1_ID2;
50:
51: CURSOR l_fav_csr(p_cle_id NUMBER) IS
52: select CLE.ID
53: from okc_k_lines_b cle , okc_line_styles_b lse
54: where cle.cle_id = p_cle_id and
55: cle.lse_id = lse.id and
56: lse.LTY_CODE = 'FIXED_ASSET';
57: BEGIN