APPS.OKL_ICG_PVT dependencies on OKX_ASST_CATGRS_V

Line 160: FROM okx_asst_catgrs_v

156: l_dummy_var VARCHAR2(1) := '?';
157:
158: CURSOR l_icgv_csr IS
159: SELECT 'x'
160: FROM okx_asst_catgrs_v
161: WHERE id1 = p_icgv_rec.iay_id
162: AND
163: NVL(TRUNC(END_DATE_ACTIVE), SYSDATE) >= TRUNC(SYSDATE);
164:

Line 192: p_token3_value => 'OKX_ASST_CATGRS_V');

188: p_token1_value => 'IAY_ID',
189: p_token2 => g_child_table_token,
190: p_token2_value => 'OKL_INS_CLASS_CATS',
191: p_token3 => g_parent_table_token,
192: p_token3_value => 'OKX_ASST_CATGRS_V');
193:
194: x_return_status := OKC_API.G_RET_STS_ERROR;
195: RETURN;
196: END IF;

Line 619: FROM OKX_ASST_CATGRS_V

615: AND (iay_id = p_icgv_rec.iay_id AND NVL(TRUNC(date_to) + 1, SYSDATE) >= SYSDATE);
616:
617: CURSOR c_asset_category_csr ( p_category_id NUMBER) IS
618: SELECT name
619: FROM OKX_ASST_CATGRS_V
620: WHERE id1 = p_category_id;
621:
622: l_asset_category OKX_ASST_CATGRS_V.name%TYPE;
623:

Line 622: l_asset_category OKX_ASST_CATGRS_V.name%TYPE;

618: SELECT name
619: FROM OKX_ASST_CATGRS_V
620: WHERE id1 = p_category_id;
621:
622: l_asset_category OKX_ASST_CATGRS_V.name%TYPE;
623:
624:
625: BEGIN
626: