APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKC_STATUSES_B

Line 153: FROM Okc_Statuses_B

149: p_cle_rec IN cle_rec_type)IS
150:
151: CURSOR l_csr1 IS
152: select 'x'
153: FROM Okc_Statuses_B
154: WHERE okc_statuses_b.code = p_cle_rec.sts_code;
155:
156: l_dummy1 VARCHAR2(1) := '?';
157: l_line_num VARCHAR2(400);

Line 154: WHERE okc_statuses_b.code = p_cle_rec.sts_code;

150:
151: CURSOR l_csr1 IS
152: select 'x'
153: FROM Okc_Statuses_B
154: WHERE okc_statuses_b.code = p_cle_rec.sts_code;
155:
156: l_dummy1 VARCHAR2(1) := '?';
157: l_line_num VARCHAR2(400);
158:

Line 181: p_token3_value => 'OKC_STATUSES_B');

177: p_token1_value => 'STS_CODE',
178: p_token2 => g_child_table_token,
179: p_token2_value => G_VIEW,
180: p_token3 => g_parent_table_token,
181: p_token3_value => 'OKC_STATUSES_B');
182: x_return_status := OKE_API.G_RET_STS_ERROR;
183: END IF;
184: END IF;
185:

Line 3830: select ste_code from okc_statuses_b where

3826: l_line_number VARCHAR2(240);
3827:
3828:
3829: cursor c_ste_code(p_status_code varchar2) is
3830: select ste_code from okc_statuses_b where
3831: code = p_status_code;
3832: l_ste_code varchar(40) := null;
3833:
3834: l_oval NUMBER ;