DBA Data[Home] [Help]

APPS.OKE_CHR_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 275: FROM FND_LOOKUP_VALUES_VL

271:
272:
273: CURSOR l_csr IS
274: SELECT 'x'
275: FROM FND_LOOKUP_VALUES_VL
276: WHERE VIEW_APPLICATION_ID = 777 AND LOOKUP_TYPE = 'PRODUCT_LINE'
277: AND NVL(ENABLED_FLAG , 'Y') = 'Y'
278: AND LOOKUP_CODE = p_chr_rec.PRODUCT_LINE_CODE
279: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE , SYSDATE - 1)

Line 303: p_token3_value =>'FND_LOOKUP_VALUES_VL');

299: p_token1_value =>'PRODUCT_LINE_CODE',
300: p_token2 =>g_child_table_token,
301: p_token2_value =>G_VIEW,
302: p_token3 =>g_parent_table_token,
303: p_token3_value =>'FND_LOOKUP_VALUES_VL');
304:
305: x_return_status := OKE_API.G_RET_STS_ERROR;
306: END IF;
307: End If;