APPS.OKC_STS_PVT dependencies on FND_LOOKUPS

Line 713: FROM Fnd_Lookups

709: ) RETURN VARCHAR2 IS
710: item_not_found_error EXCEPTION;
711: CURSOR fnd_lookup_pk_csr (p_lookup_code IN VARCHAR2) IS
712: SELECT 'x'
713: FROM Fnd_Lookups
714: WHERE fnd_lookups.lookup_type = 'OKC_STATUS_TYPE'
715: AND fnd_lookups.lookup_code = p_lookup_code;
716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
717: l_row_notfound BOOLEAN := TRUE;

Line 714: WHERE fnd_lookups.lookup_type = 'OKC_STATUS_TYPE'

710: item_not_found_error EXCEPTION;
711: CURSOR fnd_lookup_pk_csr (p_lookup_code IN VARCHAR2) IS
712: SELECT 'x'
713: FROM Fnd_Lookups
714: WHERE fnd_lookups.lookup_type = 'OKC_STATUS_TYPE'
715: AND fnd_lookups.lookup_code = p_lookup_code;
716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
717: l_row_notfound BOOLEAN := TRUE;
718: l_dummy VARCHAR2(1);

Line 715: AND fnd_lookups.lookup_code = p_lookup_code;

711: CURSOR fnd_lookup_pk_csr (p_lookup_code IN VARCHAR2) IS
712: SELECT 'x'
713: FROM Fnd_Lookups
714: WHERE fnd_lookups.lookup_type = 'OKC_STATUS_TYPE'
715: AND fnd_lookups.lookup_code = p_lookup_code;
716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
717: l_row_notfound BOOLEAN := TRUE;
718: l_dummy VARCHAR2(1);
719: BEGIN