APPS.OKL_SYP_PVT dependencies on FND_LOOKUP_VALUES

Line 1239: FROM Fnd_Lookup_Values

1235: p_REMK_PROCESS_CODE IN VARCHAR2) IS
1236:
1237: CURSOR l_processlookup_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1238: SELECT 'x'
1239: FROM Fnd_Lookup_Values
1240: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1241: AND fnd_lookup_values.lookup_type = p_lookup_type;
1242:
1243: l_dummy VARCHAR2(1);

Line 1240: WHERE fnd_lookup_values.lookup_code = p_lookup_code

1236:
1237: CURSOR l_processlookup_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1238: SELECT 'x'
1239: FROM Fnd_Lookup_Values
1240: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1241: AND fnd_lookup_values.lookup_type = p_lookup_type;
1242:
1243: l_dummy VARCHAR2(1);
1244: BEGIN

Line 1241: AND fnd_lookup_values.lookup_type = p_lookup_type;

1237: CURSOR l_processlookup_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1238: SELECT 'x'
1239: FROM Fnd_Lookup_Values
1240: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1241: AND fnd_lookup_values.lookup_type = p_lookup_type;
1242:
1243: l_dummy VARCHAR2(1);
1244: BEGIN
1245: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1289: FROM Fnd_Lookup_Values

1285: p_REMK_ITEM_INVOICED_CODE IN VARCHAR2) IS
1286:
1287: CURSOR l_processlookup_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1288: SELECT 'x'
1289: FROM Fnd_Lookup_Values
1290: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1291: AND fnd_lookup_values.lookup_type = p_lookup_type;
1292:
1293: l_dummy VARCHAR2(1);

Line 1290: WHERE fnd_lookup_values.lookup_code = p_lookup_code

1286:
1287: CURSOR l_processlookup_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1288: SELECT 'x'
1289: FROM Fnd_Lookup_Values
1290: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1291: AND fnd_lookup_values.lookup_type = p_lookup_type;
1292:
1293: l_dummy VARCHAR2(1);
1294: BEGIN

Line 1291: AND fnd_lookup_values.lookup_type = p_lookup_type;

1287: CURSOR l_processlookup_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1288: SELECT 'x'
1289: FROM Fnd_Lookup_Values
1290: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1291: AND fnd_lookup_values.lookup_type = p_lookup_type;
1292:
1293: l_dummy VARCHAR2(1);
1294: BEGIN
1295: x_return_status := OKL_API.G_RET_STS_SUCCESS;