APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_STATUSES_B

Line 90: OKC_STATUSES_B STS

86:
87: CURSOR l_k_sts_csr IS
88: select k.sts_code, sts.ste_code
89: from OKC_K_HEADERS_B K,
90: OKC_STATUSES_B STS
91: where STS.CODE = K.STS_CODE
92: and K.ID = p_chr_id;
93:
94: Cursor l_strmtyp_id_csr IS

Line 115: l_ste_code OKC_STATUSES_B.STE_CODE%type:= null;

111: x_okl_cle_id okc_k_lines_b.id%type := null;
112: l_rel_vers_id number := null;
113: l_strmtyp_id okl_strm_tmpt_full_uv.sty_id%type := null;
114: l_sts_code OKC_K_HEADERS_B.sts_code%type:= null;
115: l_ste_code OKC_STATUSES_B.STE_CODE%type:= null;
116:
117: l_api_name CONSTANT VARCHAR2(30) := 'create_contract_link_serv';
118: l_api_version CONSTANT NUMBER := 1.0;
119: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;